NTSB investigations, 2016, NC

7 cases where the sequence of events included Nose over/nose down.

Cases per year

20082026
NTSB investigations, 2016, NC per year, 2008–2026: 46 cases
20082
20091
20103
20113
20121
20133
20144
20151
20167
20173
20183
20191
20203
20215
20221
20234
20251

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\" = 'NC' 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\" = '096' 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 ERA17LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Snow Hill, NCThe total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.Nov 10, 2016 · N23473 · Substantial damageNTSB GAA17CA028Accident · Minor injuriesData collectionFinal reportNewkirk Thomas Ray Vans RV 6 · Garland, NCThe pilot's improper landing flare, which resulted in a bounced landing on the grass runway.Oct 12, 2016 · N164N · Substantial damageNTSB ERA16CA222Accident · No injuriesData collectionFinal reportCessna 172M · Lenoir, NCThe student pilot’s failure to compensate for gusting wind conditions during landing, which resulted in a bounced landing. Contributing to the accident was the flight instructor’s inadequate review of the weather conditions with the student and his inadequate…Jun 16, 2016 · N12184 · Substantial damageNTSB GAA16CA304Accident · No injuriesData collectionFinal reportCessna 120 · Climax, NCAn evasive maneuver during the landing roll to avoid deer on the runway, which resulted in a runway excursion and a nose over. Contributing to the accident was the lack of an airport perimeter fence.Jun 10, 2016 · N77216 · Substantial damageNTSB ERA16LA181Accident · No injuriesLimited investigationFinal reportMaule M 7-235B · Littleton, NCThe pilot's improper landing flare, which resulted in a hard landing and subsequent damage to the left float.Apr 24, 2016 · N367FS · Substantial damageNTSB ERA16LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2008 · Burgaw, NCThe pilot’s failure to activate the airplane’s alternator, which resulted in an eventual loss of electrical power to the engine’s fuel pumps, fuel starvation, and a total loss of engine power. Contributing was the pilot’s use of an incomplete checklist.Apr 16, 2016 · N588TA · Substantial damageNTSB GAA16CA183Accident · Minor injuriesData collectionFinal reportPiper PA22 · Pantego, NCA loss of directional control during the takeoff roll in gusting wind conditions, which resulted in a runway excursion, a nose over, and an impact with terrain. Contributing to the accident was the pilot's decision to takeoff in gusting crosswind conditions.Apr 9, 2016 · N5069Z · Substantial damage