NTSB investigations, 2022
74 cases where the sequence of events included Nose over/nose down.
Cases, newest first
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\") = 2022
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.
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") = 2022 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ANC22LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Willow, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.NTSB WPR22LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Estancia, NMThe pilot’s decision to land on an unsuitable surface which resulted in his loss of aircraft control.NTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA22LA224Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Somerville, TNThe inadequate inspection and maintenance of the engine exhaust system, which resulted in an in-flight fire.NTSB ERA22LA211Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe pilot’s failure to maintain directional control while attempting to land in a crosswind.NTSB ERA22LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s failure to attain the proper touchdown point which resulted in a runway overrun.NTSB CEN22LA182Accident · No injuriesClass 4 · LimitedFinal reportPiper-Harris J3C-65 · Hartford, WIThe flight instructor lost control of the airplane while taxiing in gusty wind conditions.NTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.NTSB ERA22LA184Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Bald Head Island, NCThe pilot’s failure to maintain control during landing on a soft surface.NTSB ERA22LA185Accident · No injuriesClass 4 · LimitedFinal reportPF Cub Flyers CCK-2000 · Collegedale, TNThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion and a subsequent nose-over.NTSB WPR22LA139Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Swan Valley, IDThe pilot’s failure to maintain airplane control during the landing roll on a snow-covered runway surface.NTSB CEN22LA156Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Springtown, TXA total loss of engine power for reasons that could not be determined.NTSB CEN22LA174Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Paragould, ARThe student pilot’s failure to maintain directional control during landing which resulted in a ground loop.NTSB WPR22LA129Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Belgrade, MTThe pilots misjudged landing approach, which resulted in a long landing and collision with a fence.NTSB ERA22LA164Accident · Minor injuriesClass 4 · LimitedFinal reportHartz Paul RV-6A · Lake City, FLThe pilot’s improper landing flare, which resulted in overload bending of the nose landing gear leg and subsequent nose-over.NTSB ERA22LA157Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Harveysburg, OHA complete loss of engine power as a result of carburetor ice due to the flight instructor’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA22LA152Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Plainville, CTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR22LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Nampa, IDThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB ERA22LA158Accident · No injuriesClass 4 · LimitedFinal reportAxell Charles L RV-6 · Laurens, NYThe pilot’s failure to maintain directional control during landing.NTSB CEN22LA142Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Kokomo, INThe pilot’s decision to perform the takeoff on the soft, wet, turf runway, with the tailwheel equipped airplane, which resulted in a nose-over.NTSB ERA22LA128Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Pahokee, FLThe student pilot’s incorrect tail wheel takeoff procedure, and the flight instructor’s lack of remedial action, which resulted in a nose over.NTSB ANC22LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Kasilof, AKThe pilot’s decision to land on an unmaintained runway surface, which resulted in a loss of control and nose over.NTSB CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.NTSB WPR22LA074Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Jordan Valley, ORThe pilot’s decision to takeoff on remote snow covered terrain which, resulted in a nose-over.