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 WPR12LA275Accident · No injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Fontana, CAPartial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…NTSB WPR12CA355Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe student pilot's failure to maintain directional control and subsequent excessive braking during the landing roll with a tailwind, which resulted in a noseover.NTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.NTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.NTSB WPR12LA272Accident · No injuriesLimited investigationFinal reportCessna 150F · Jackson, CAThe student pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB CEN12LA386Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Walnut Ridge, ARThe pilot's failure to maintain aircraft control after encountering a whirlwind or dust-devil during the landing flare.NTSB WPR12CA308Accident · No injuriesData collectionFinal reportCessna 180A · Cascade, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA12LA405Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilots’ operation of the airplane with an insufficient supply of engine oil, resulting in engine seizure and total loss of engine power.NTSB ERA12LA400Accident · No injuriesLimited investigationFinal reportBarney Oldfield Baby Lakes · Anderson, SCA total loss of engine power as a result of an inadequate amount of lubricating oil in the engine. Contributing to the accident was the pilot's improper preflight inspection.NTSB ERA12CA393Accident · No injuriesData collectionFinal reportNorth American AT-6C · Delmar, DEThe pilot's failure to go around after not attaining the proper touchdown point, which resulted in a runway excursion and noseover.NTSB WPR12CA242Accident · No injuriesData collectionFinal reportGrumman G-164A · Riverton, WYThe pilot's loss of directional control during the landing roll and his deliberate application of excessive braking pressure, which resulted in a noseover.NTSB ERA12CA377Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Lawrence, MAThe pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.NTSB ANC12CA044Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Tok, AKThe pilot's inadvertent and excessive application of brake pressure during landing, which resulted in a nose over.NTSB WPR12LA264Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Twentynine Palms, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12CA226Accident · Minor injuriesData collectionFinal reportCessna 182M · Vashon Island, WAThe pilot's loss of directional control during a rejected takeoff, which resulted in a noseover.NTSB ERA12CA361Accident · No injuriesData collectionFinal reportLydon Patrick F Searey · Sanford, FLThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB ANC12CA041Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Talkeetna, AKThe pilot inadvertently landed with the parking brake set.NTSB ERA12LA343Accident · No injuriesLimited investigationFinal reportCessna 195A · Tipton, PAA fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.NTSB ERA12CA339Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Gulf Shores, ALThe pilot's inadvertent application of the wheel brakes immediately after landing, which resulted in the airplane nosing over.NTSB CEN12LA298Accident · Minor injuriesLimited investigationFinal reportPool Murphy Moose · Steamboat Springs, COA locked left brake for reasons that could not be determined because independent observations of the postaccident condition of the airplane could not be performed, and the pilot’s subsequent loss of control.NTSB CEN12CA303Accident · No injuriesData collectionFinal reportCessna 182S · Houston, TXThe student pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.NTSB ERA12CA320Accident · Minor injuriesData collectionFinal reportCessna 172F · Cambridge, NYThe pilot’s loss of airplane control during a takeoff in variable crosswind conditions.NTSB WPR12CA234Accident · No injuriesData collectionFinal reportMurphy Rebel · Hayden Lake, IDThe pilots’ failure to position the landing gear for landing on the water, which resulted in a nose-over.NTSB WPR12LA190Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Elberta, UTA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA312Accident · Minor injuriesLimited investigationFinal reportShoup Ronald R RV-6A · Milton, FLA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12CA311Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Eaton, NYThe pilot's improper approach to landing, which resulted in the airplane touching down short of the runway.NTSB ERA12LA306Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Fowler's Bluff, FLThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR12LA182Accident · No injuriesLimited investigationFinal reportMays Kitfox Lite 2 · Cedarville, CAA loss of engine power during cruise flight due to air in the fuel system. Contributing to the accident was the pilot’s incorrect maintenance that did not properly secure the fuel lines.NTSB CEN12LA255Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Wildorado, TXThe loss of engine power for undetermined reasons.NTSB WPR12CA177Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Sierraville, CAThe pilot did not maintain directional control during the landing roll.NTSB ERA12LA293Accident · No injuriesLimited investigationFinal reportPrendergast John/Vans RV-7A · Gerrardstown, WVThe pilot/builder's misjudgment of the required spacer width needed after engine housing lap grinding, which resulted in bearing oil hole misalignment and insufficient internal engine lubrication.NTSB WPR12CA170Accident · No injuriesData collectionFinal reportCessna 180F · McCall, IDThe pilot did not maintain directional control during the landing roll.NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.NTSB ERA12CA275Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Ruleville, MSThe pilot's inadequate preflight planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12CA293Accident · No injuriesData collectionFinal reportCessna 152 · Lee's Summit, MOThe student pilot’s loss of directional control while landing.NTSB WPR12CA159Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Westport, WAThe pilot’s inadequate crosswind compensation, which resulted in a loss of directional control during the landing roll.NTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.NTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB CEN12LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Arcola, TXA total loss of engine power during landing approach 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 CEN12LA209Accident · 1 fatalLimited investigationFinal reportWalling Vans RV-3 · Larchwood, IAThe pilot's failure to maintain directional control of the airplane after landing.NTSB CEN12CA207Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Crowley, LAThe student pilot's improper landing flare, which resulted in a nose-over.NTSB WPR12CA148Accident · No injuriesData collectionFinal reportStinson 108-1 · Coolin, IDThe pilot’s decision to land on a snow-covered runway.NTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.NTSB CEN12CA200Accident · Minor injuriesData collectionFinal reportCessna 172P · Colorado Springs, COThe pilot did not maintain control of the airplane during takeoff, which resulted in a hard landing and subsequent nose over.NTSB WPR12LA135Accident · Minor injuriesLimited investigationFinal reportCook Smith AVN Replica SU · St. Johns, AZThe pilots’ failure to maintain directional control when the right brake locked up during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12CA127Accident · No injuriesData collectionFinal reportCessna 172N · Kelso, WAThe pilot did not maintain directional control during the landing flare.NTSB ERA12CA220Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Beverly, MAThe pilot's loss of airplane control during takeoff, which resulted in a runway excursion.NTSB ANC12CA023Accident · No injuriesData collectionFinal reportCessna 182A · Anchorage, AKThe pilot's inadvertent landing on a frozen lake in dark night conditions.NTSB ERA12CA211Accident · No injuriesData collectionFinal reportCessna 172M · Mayaquez, PRThe pilot did not maintain control of the airplane while landing in crosswind conditions.NTSB CEN12CA160Accident · No injuriesData collectionFinal reportCessna 180 · South Fork, COThe pilot's loss of directional control while landing on a patchy snow-covered runway.