NTSB investigations, 2018, IN

5 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2018, IN per year, 2008–2026: 84 cases
20085
20095
20105
20114
201210
20135
20145
20153
20165
20177
20185
20194
20204
20212
20222
20232
20247
20253
20261

Latest cases

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 2018
    AND c.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB CEN19FA036Accident · 3 fatalClass 3 · FieldFinal reportCessna 525 · Memphis, INThe pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.Nov 30, 2018 · N525EG · DestroyedNTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…Nov 29, 2018 · N7751Y · DestroyedNTSB GAA18CA424Accident · No injuriesData collectionFinal reportBell 206 · New Castle, INThe pilot's failure to ensure that the fill hose was disconnected from the helicopter before takeoff, which resulted in the fill hose striking the tail rotor and the subsequent loss of tail rotor effectiveness. Contributing to the accident was inadequate…Jul 16, 2018 · N39LR · Substantial damageNTSB CEN18LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-200 · Valparaiso, INThe pilot receiving instruction’s failure to maintain a safe operating airspeed, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's failure to monitor the pilot's airspeed control.May 8, 2018 · N99GN · Substantial damageNTSB CEN18FA107Accident · 3 fatalField investigationFinal reportCessna 441 · Rossville, INAn in-flight loss of control for reasons that could not be determined based on the available evidence.Feb 23, 2018 · N771XW · Destroyed