NTSB investigations, 2016, MO

6 cases where the sequence of events included Abnormal runway contact.

Cases per year

20082026
NTSB investigations, 2016, MO per year, 2008–2026: 31 cases
20082
20093
20103
20112
20123
20152
20166
20171
20181
20203
20211
20222
20241
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\") = 2016
    AND c.\"eventStateOrRegion\" = 'MO' 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\" = '090' 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 GAA17CA120Accident · No injuriesData collectionFinal reportPiper PA28 · St. Louis, MOThe student pilot's improper landing flare, which resulted in a bounced landing.Nov 27, 2016 · N56809 · Substantial damageNTSB GAA17CA046Accident · No injuriesData collectionFinal reportCirrus SR22 · Kirksville, MOThe pilot’s improper compensation for changing wind during the landing flare, which resulted in an off-centered landing and a subsequent loss of directional control.Oct 23, 2016 · N528HB · Substantial damageNTSB GAA16CA386Accident · No injuriesData collectionFinal reportCessna 172 · Chesterfield, MOThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.Jul 18, 2016 · N128RM · Substantial damageNTSB GAA16CA192Accident · No injuriesData collectionFinal reportCessna E162 · Lee's Summit, MOThe flight instructor's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and collision with a taxiway sign.Apr 12, 2016 · N7027F · Substantial damageNTSB GAA16CA217Accident · No injuriesData collectionFinal reportCessna A185 · Chesterfield, MOThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and a wing strike.Apr 9, 2016 · N4095A · Substantial damageNTSB DCA16LA100Accident · No injuriesLimited investigationFinal reportEmbraer EMB145 · St Louis, MOthe flight crews' failure to consider all available runways for landing to minimize the gusty crosswind component. Contributing to the accident was the captain's reduction of the engine thrust for about 1 second at low altitude immediately after the first…Feb 24, 2016 · N856HK · Substantial damage