NTSB investigations, 2009, NE

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

Cases per year

20082026
NTSB investigations, 2009, NE per year, 2008–2026: 57 cases
20084
20097
20105
20111
20125
20134
20141
20153
20163
20173
20184
20191
20202
20214
20223
20233
20244

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\") = 2009
    AND c.\"eventStateOrRegion\" = 'NE' 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 CEN10LA012Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Weeping Water, NEThe pilot’s failure to maintain aircraft control resulting in a stall. Contributing to the accident was the stuck exhaust valve resulting in the partial loss of engine power.Oct 11, 2009 · N1536B · Substantial damageNTSB CEN10CA013Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Bingham, NEThe pilot's impairment due to alcohol consumption and failure to maintain aircraft control.Oct 9, 2009 · N54750 · Substantial damageNTSB CEN09CA429Accident · Minor injuriesData collectionFinal reportCessna A188B · Elwood, NEThe pilot's inability to maintain a climb after takeoff due to wind shift or downdraft.Jul 12, 2009 · N4990Q · Substantial damageNTSB CEN09CA366Accident · Serious injuriesData collectionFinal reportSabre 2PL · Harrison, NEA loss of directional control for undetermined reasons.Jun 16, 2009 · N2811P · Substantial damageNTSB CEN09LA350Accident · 1 fatalLimited investigationFinal reportPeterson Allen L Dragonfly II · Arthur, NEThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's impairment due to the use of a over-the-counter medication with sedative effects and spatial disorientation.Jun 11, 2009 · N360KK · DestroyedNTSB CEN09CA289Accident · No injuriesData collectionFinal reportJihlavan KP · Crete, NEThe pilot's failure to maintain directional control of the airplane during takeoff.May 10, 2009 · N21KP · Substantial damageNTSB CEN09LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Wood Lake, NEThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.Mar 4, 2009 · N3352B · Substantial damage