NTSB investigations
2,290 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 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 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 GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.NTSB GAA18CA165Accident · No injuriesData collectionFinal reportBellanca 1413 · Anacortes, WAThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA153Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Many, LAThe pilot’s improper application of the brakes during landing, which resulted in a nose-over.NTSB GAA18CA160Accident · No injuriesData collectionFinal reportCessna 172 · England, ARThe pilot’s failure to detect water in the fuel system during the preflight inspection, which resulted in a loss of engine power during departure and a subsequent impact with terrain.NTSB WPR18LA102Accident · No injuriesClass 3 · LimitedFinal reportMacdonald Craig MAC CUB · Ogden, UTThe pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing.NTSB GAA18CA154Accident · No injuriesData collectionFinal reportCessna 207 · Newtok, AKThe pilot’s failure to maintain directional control during takeoff. Contributing to the accident was the pilot’s failure to properly check that the flight controls were correctly configured before takeoff.NTSB GAA18CA141Accident · No injuriesData collectionFinal reportCessna 172 · Show Low, AZThe flight instructor’s failure to maintain directional control during the landing roll in gusting crosswind and tailwind conditions.NTSB GAA18CA139Accident · No injuriesData collectionFinal reportCessna 402 · Mount Sterling, KYThe pilot’s failure to maintain directional control during the landing roll on a wet surface.NTSB GAA18CA135Accident · No injuriesData collectionFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB CEN18LA102Accident · Serious injuriesLimited investigationFinal reportScheineman-Van Buren T 18 · Longmont, COThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a groundloop and nose over.NTSB GAA18CA182Accident · No injuriesData collectionFinal reportHeinlein George GH125 · Valkaria, FLThe pilot’s decision to exit the paved runway into soft terrain, which resulted in a ground loop and landing gear collapse.NTSB GAA18CA119Accident · No injuriesData collectionFinal reportCessna 172 · Juneau, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA18CA120Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Paula, CAThe pilot’s failure to maintain directional control during landing due to being distracted by another airplane and her delayed initiation of a go-around, during which the right wing struck a parked helicopter.NTSB ERA18LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Babylon, NYThe partial loss of engine power after a simulated engine failure for reasons that could not be determined because a postaccident examination and an engine test run did not reveal any anomalies that would have precluded normal operation.NTSB GAA18CA112Accident · No injuriesData collectionFinal reportCessna 172 · Silver City, NMThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing.NTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA106Accident · No injuriesData collectionFinal reportCessna A185 · Lowman, IDThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.NTSB GAA18CA101Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Winnimucca, NVThe pilot’s failure to maintain directional control and her use of excessive braking during landing, which resulted in a nose-over.NTSB GAA18CA100Accident · No injuriesData collectionFinal reportCessna 170 · Auburn, NYThe pilot’s improper wind correction inputs while taxiing with a quartering tailwind.NTSB GAA18CA099Accident · No injuriesData collectionFinal reportCubcrafters CC11 · Spanish Fork, UTThe pilot’s incorrect brake application during the landing roll, resulting in a nose over.NTSB GAA18CA116Accident · No injuriesData collectionFinal reportBeech B19 · Meadville, PAThe student pilot’s failure to maintain directional control during landing.NTSB WPR18LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 150L · Perris, CAThe presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor.NTSB CEN18LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Longmont, COThe failure of the landing gear through bolt primarily due to fatigue during a hard landing, which resulted in a landing gear collapse and runway excursion. Contributing to the accident was noncompliance with the manufacturer service letter.NTSB GAA18CA090Accident · No injuriesData collectionFinal reportPiper PA22 · Yentna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and subsequent nose-over.NTSB GAA18CA068Accident · No injuriesData collectionFinal reportNorth American T 6 · Chesapeake, VAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB ERA18LA043Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Frederick, MDThe pilot's improper landing flare, which resulted in a bounced landing and the failure of the left main landing gear tire.NTSB ERA18CA035Accident · No injuriesData collectionFinal reportDriggers Quillan E Titan Tornado · Mechanicsville, VAThe pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff.NTSB ANC18CA017Accident · No injuriesData collectionFinal reportPiper PA 18-125 · Nikolai, AKThe pilot’s improper decision to contact an unsuitable landing surface, which resulted in a nose-over.NTSB CEN18LA043Accident · No injuriesLimited investigationFinal reportRutten Phil J Pietenpol · De Kalb, ILThe pilot’s excessive rudder and brake applications during landing, which caused the airplane to nose over.NTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA042Accident · No injuriesData collectionFinal reportStinson SR 5E · Burlington, WAThe pilot’s unstabilized approach, which resulted in a hard, bounced landing and nose-over. Also causal to the accident was the pilot’s improper decision to land on a closed alternate grass landing area.NTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.NTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.NTSB ERA18LA023Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A · Montague, MAThe pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.NTSB GAA18CA052Accident · No injuriesData collectionFinal reportCessna 182 · Skwentna, AKThe pilot’s decision to land on an unimproved snow-covered airstrip, which resulted in the airplane coming to rest inverted.NTSB CEN18CA021Accident · No injuriesData collectionFinal reportCessna T210N · Eagle, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA18CA019Accident · No injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Dayton, OHThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB GAA18CA027Accident · No injuriesData collectionFinal reportCessna 120 · New Bern, NCThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB GAA18CA025Accident · No injuriesData collectionFinal reportChampion 7GC · Gerlach, NVThe pilot's incorrect pitch control during the landing roll in shifting wind conditions, which resulted in a nose-over.NTSB CEN18LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Willmar, MNThe pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing.NTSB WPR18LA009Accident · No injuriesLimited investigationFinal reportBarber Warren D Turbine Cubs P A 18 · Skull Valley, UTThe activation of the wheel brakes during landing, which resulted in a nose-over. The reason for the wheel brake activation could not be determined.NTSB CEN18LA013Accident · No injuriesLimited investigationFinal reportRussell E Oberg Murphy Rebel · Fort Collins, COA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB ERA18LA003Accident · Minor injuriesClass 3 · LimitedFinal reportFreeman Heritage Collection SE5A · Virginia Beach, VAA partial loss of engine power due to an interruption of the normal fuel/air mixture to the engine.NTSB WPR18LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Tonopah, NVThe pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…NTSB ERA17LA340Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Ocklawaha, FLA failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.NTSB GAA17CA561Accident · No injuriesData collectionFinal reportAmerican Legend AL18 · Bessemer, ALThe student pilot’s incorrect application of the brakes and subsequent failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.NTSB GAA17CA565Accident · No injuriesData collectionFinal reportPiper PA18 · Holy Cross, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.