NTSB investigations
2,288 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 ERA15CA021Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Everglades City, FLThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, runway excursion, and collision with vegetation and water.NTSB ERA15LA014Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Boca Raton, FLMaintenance personnel’s failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1 and 2 main bearings, loss of lubrication, failure of the crankshaft, and a subsequent total loss of engine power.NTSB CEN15CA016Accident · No injuriesData collectionFinal reportCessna 180B · Coloma, MIThe pilot did not use the departure checklist, resulting in an inadvertent landing with the pontoon wheels extended.NTSB ANC15CA001Accident · No injuriesData collectionFinal reportCessna 180J · Gustavus, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB WPR15LA003Accident · No injuriesLimited investigationFinal reportCorben Baby Ace D · Lincoln, CAThe total loss of engine power due to fuel starvation, which resulted from debris restricting the fuel flow within the fuel system.NTSB ANC14LA085Accident · No injuriesLimited investigationFinal reportCessna TU206 · Deadhorse, AKThe application of insufficient torque to the engine cylinder through bolts during the replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 bearing, oil starvation, and a catastrophic engine failure.NTSB WPR14CA384Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Meadow Creek, MTThe pilot's inadequate landing flare and failure to maintain aircraft control during landing.NTSB ERA14TA435Accident · No injuriesFinal reportCessna T210N · Gaithersburg, MDThe pilot’s failure to execute a missed approach after recognizing that the airplane was not aligned with the wet runway, which resulted in a long landing with a tailwind and a subsequent runway overrun.NTSB ANC14CA078Accident · No injuriesData collectionFinal reportCessna 180H · Nenana, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, while landing during dark night conditions.NTSB CEN14LA497Accident · Serious injuriesLimited investigationFinal reportDarney Glasair III · Austin, TXThe pilot’s use of an improper attitude and airspeed during landing followed by excessive braking, which resulted in the airplane wheelbarrowing on the runway and a subsequent loss of directional control.NTSB ANC14CA081Accident · No injuriesData collectionFinal reportMaule M 5-235C · Talkeetna, AKThe pilot's excessive taxi speed, which resulted in a loss of control.NTSB WPR14CA366Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Black Rock City, NVThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's disorientation as a result of dust which reduced visibility.NTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.NTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.NTSB ERA14LA423Accident · 1 fatalLimited investigationFinal reportMcmurray David C Searey · Webb, NYThe pilot’s failure to maintain control of the amphibious airplane while practicing touch-and-go takeoffs and landings on a reservoir.NTSB CEN14LA492Accident · No injuriesLimited investigationFinal reportCampbell Super Bearhawk · Sault Ste Marie, MIThe pilot’s inadequate flare during landing on water with a glassy condition, which resulted in the airplane nosing over.NTSB ANC14CA075Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Homer, AKThe pilot's failure to maintain aircraft control during the landing roll.NTSB ANC14CA073Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's excessive use of brakes during the landing roll resulting in a nose over.NTSB CEN14LA472Accident · No injuriesLimited investigationFinal reportOhlgren Brent E RV-6A · Marshalltown, IAA loss of engine power due to fuel exhaustion as a result of the pilot's misjudgment of the amount of fuel onboard prior to flight.NTSB WPR14LA353Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Pahrump, NVA total loss of engine power during a practice autorotation for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA402Accident · Minor injuriesLimited investigationFinal reportThibault Michael L RV4 · Polk Township, PAA total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB CEN14LA439Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Wray, COA loss of the No. 1 cylinder’s compression due to a stuck exhaust valve caused by a lack of sufficient valve clearance, which resulted in a loss of engine power and a forced landing. Contributing to the loss of engine power were the worn intake and exhaust…NTSB ERA14CA408Accident · No injuriesData collectionFinal reportDay William L Minicoupe · Baltimore, MDThe pilot/owner/builder's improper weight and balance calculations, which rendered the airplane uncontrollable in the pitch axis.NTSB ERA14CA394Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · Readington, NJThe pilot's failure to maintain aircraft control during landing which resulted in an aircraft nose-over.NTSB CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ANC14CA064Accident · No injuriesData collectionFinal reportCessna 182A · Gustavus, AKThe pilot's unstable landing approach which resulted in a long landing, and subsequent collision with terrain.NTSB ERA14LA383Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S · Sarasota, FLA total loss of engine power due to fuel exhaustion, which resulted from the flight instructor's inadequate preflight fuel planning.NTSB ANC14CA063Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilots excessive use of the airplanes brakes during the landing roll, which resulted in a nose over. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.NTSB ERA14LA382Accident · Minor injuriesLimited investigationFinal reportJackson Jeremiah D Vans RV6A · West Palm Beach, FLThe pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…NTSB ERA14CA385Accident · No injuriesData collectionFinal reportCote James Rans S 6S · New Berlin, PAThe passenger's inadvertent interference with the rudder controls during the takeoff.NTSB WPR14CA326Accident · No injuriesData collectionFinal reportPiper PA20 - Undesignat · Dayton, ORThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB CEN14CA404Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Traverse City, MIThe pilot's loss of directional control during landing, resulting in a runway excursion and the airplane nosing over.NTSB CEN14CA381Accident · No injuriesData collectionFinal reportCessna 150D · Greenfield, INThe student pilot failed to maintain directional control while landing with a crosswind.NTSB CEN14LA388Accident · No injuriesLimited investigationFinal reportCessna 177B · Georgetown, TXThe pilot’s improper recovery from a bounced landing.NTSB CEN14CA386Accident · No injuriesData collectionFinal reportBlack Christopher Sparrow Sport Spec · Moriarty, NMThe pilot's loss of directional control while landing in gusty crosswind conditions. Contributing to the accident was the pilot's operation of the engine above its normal temperature limit on takeoff.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB CEN14CA384Accident · No injuriesData collectionFinal reportCessna T206H · Sterling City, TXThe pilot's failure to maintain directional control of the airplane during the crosswind landing.NTSB ANC14LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s inadvertent application of excessive brake pressure during landing on a rough surface, which resulted in a nose-over.NTSB ERA14CA395Accident · No injuriesData collectionFinal reportBoeing E75N1 · Penridge, PAThe pilot's delayed action in correcting a drift to the right during landing roll and his improper use of the wheel brakes which resulted in the airplane nosing over.NTSB CEN14LA373Accident · Serious injuriesLimited investigationFinal reportGarramone Mike A Vixen · Columbus, NMA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB CEN14CA370Accident · No injuriesData collectionFinal reportCessna 120 · Midland, MIThe pilot's failure to maintain sufficient airspeed and his delayed application of engine power while on short final which resulted in a hard landing.NTSB CEN14CA368Accident · Minor injuriesData collectionFinal reportMckenzie Douglas E Stol CH750 · Dodgeville, MIThe pilot's failure to maintain control of the airplane during takeoff resulting in an impact with a tree and terrain.NTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…NTSB ERA14CA349Accident · No injuriesData collectionFinal reportPekola James W Ridge Runner III · Andrews, NCThe pilot's failure to open the fuel tank valves during the preflight examination of the airplane, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR14CA291Accident · Minor injuriesData collectionFinal reportDelconte Emidio J Kitfox Series V · Cove, ORThe pilot's failure to maintain directional control during takeoff when the airplane encountered standing water on the airstrip.NTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14FA327Accident · 1 fatalField investigationFinal reportCessna 140 · Parma, NYThe pilot's decision to land with a quartering tailwind and his failure to maintain directional control during the landing roll. Contributing to the severity of the pilot's injuries was the failure of the aluminum center safety belt bracket.NTSB CEN14CA343Accident · Minor injuriesData collectionFinal reportCessna 170B · Tomball, TXThe pilot's loss of directional control during landing rollout, which resulted in a runway excursion and the tailwheel airplane nosing over.NTSB CEN14CA344Accident · Minor injuriesData collectionFinal reportPiper PA 25-235 · Rhinelander, WIA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.NTSB ERA14CA317Accident · Minor injuriesData collectionFinal reportCessna 172S · Orlando, FLThe flight instructor's failure to maintain control while taxiing in a strong gusty wind.