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 ANC12CA112Accident · No injuriesData collectionFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA12LA574Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Corinth, MSThe improper torque application on the crankshaft gear bolt by maintenance personnel during an engine overhaul, which resulted in the fatigue failure of the locking tab washer and gear alignment dowel and subsequent engine stoppage. Contributing to the…NTSB CEN12LA635Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mecosta, MIThe pilot's improper landing flare, which resulted in a bounced landing and loss of airplane control.NTSB ANC12CA108Accident · No injuriesData collectionFinal reportCessna 172K · Atqasuk, AKThe student pilot's failure to maintain directional control while performing a high-speed taxi in windy conditions.NTSB WPR12LA409Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Monroe, WAA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA402Accident · Serious injuriesLimited investigationFinal reportHansen HANSEN-VANS RV-6 · Lemolo Lake, ORAn overvoltage event due to the failure of the automotive voltage regulator, which resulted in electrical anomalies and smoke in the cockpit and a subsequent forced off-airport landing.NTSB ERA12CA547Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a takeoff in gusty crosswind conditions. Contributing to the accident was the pilot's decision to take off in gusty wind conditions associated with approaching…NTSB WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.NTSB CEN12CA608Accident · No injuriesData collectionFinal reportRolladen-Schneider OHG LS3-A · Navasota, TXThe pilot’s inadequate compensation for landing area conditions during an off-airport landing, which resulted in a loss of directional control and a collision with terrain.NTSB WPR12CA388Accident · Minor injuriesData collectionFinal reportPiggott John H Bearhawk · Sequim, WAThe student pilot's failure to maintain directional control on landing.NTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB ERA12LA539Accident · No injuriesLimited investigationFinal reportCessna 172M · Canadensis, PAThe pilot’s failure to attain a proper glidepath.NTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.NTSB CEN12LA589Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Ralls, TXThe total loss of engine power due to a fatigue failure of the rocker arm journal casting of the rocker arm cap.NTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.NTSB CEN12LA580Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe partial loss of engine power due to debris lodged beneath the throttle body of the carburetor venturi.NTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.NTSB WPR12CA363Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8E · Hillsboro, ORThe pilot’s improper use of the brakes during the landing roll, which resulted in a nose over.NTSB CEN12LA556Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sidney, NEThe pilot's misuse of the brakes during landing, which resulted in the airplane nosing over.NTSB ERA12CA520Accident · No injuriesData collectionFinal reportFleet Fleet 16B · Bayport, NYThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA12CA517Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Gum Neck, NCThe pilot's failure to maintain airplane control during the takeoff roll. Contributing to the accident was the rough condition of the runway.NTSB ANC12CA088Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's loss of control during the landing roll in gusting wind conditions, which resulted in the airplane nosing over.NTSB ANC12CA086Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe passenger's inadvertent application of the brake pedals during landing, which resulted in a noseover.NTSB CEN12CA537Accident · No injuriesData collectionFinal reportGage Midget Mustang MM-1 · Erie, COThe pilot's inadequate compensation for the crosswind conditions during takeoff, which resulted in a loss of directional control.NTSB ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.NTSB CEN12FA520Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fate, TXA total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.NTSB WPR12CA353Accident · No injuriesData collectionFinal reportCessna 182 · Joseph, ORThe pilot’s excessive use of brakes during the landing roll in a gusting crosswind, which resulted in a noseover.NTSB CEN12LA493Accident · No injuriesLimited investigationFinal reportCessna 182G · Montrose, COThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB CEN12CA499Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hutchinson, KSThe pilot’s loss of directional control during the landing roll.NTSB WPR12CA322Accident · No injuriesData collectionFinal reportCubCrafters CC 11-160 · Stanley, IDThe pilot’s excessive use of the brakes during the landing roll.NTSB CEN12LA470Accident · Minor injuriesLimited investigationFinal reportYamokoski William Glastar · Chicago, ILFailure of the automotive engine's reduction gearbox while in cruise flight.NTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.NTSB ANC12CA078Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Talkeetna, AKThe flight instructor's and student pilot's excessive application of brakes during an aborted takeoff, which resulted in a noseover.NTSB WPR12LA313Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Wells, NVA loss of engine power during the final landing approach for reasons that could not be determined because postaccident examination did not reveal any malfunctions or failures that would have precluded normal operation.NTSB CEN12LA455Accident · No injuriesLimited investigationFinal reportCessna 175A · Shelby, ILThe loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation.NTSB WPR12LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockford, IDA partial loss of engine power during cruise flight due to the failure of the No. 3 cylinder exhaust valve for reasons that could not be determined due to the damage to the valve head and the missing valve stem. Contributing to the accident was the flight…NTSB ERA12LA456Accident · Serious injuriesLimited investigationFinal reportSeibert Robert M Seibert RV-6 · Ridgeland, SCThe pilot's inadvertent use of the wheel brakes during touchdown and his failure to maintain directional control. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.NTSB CEN12CA430Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Williston, NDThe pilot's failure to ensure a suitable landing surface.NTSB CEN12LA424Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Bedford, INThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to return home.NTSB ERA12CA434Accident · Minor injuriesData collectionFinal reportJones Peter M Boeing/Jones 75 · Bayport, NYThe airplane’s encounter with a wind shift to a tailwind during takeoff, which resulted in the pilot’s decision to abort the takeoff and the airplane’s subsequent runway overrun.NTSB ANC12CA071Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's excessive use of brakes during landing, which resulted in a noseover.NTSB ANC12LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-180 · Chugiak, AKThe pilot/airplane owner’s loss of directional control after landing, and the instructor pilot's lack of adequate supervision of the training flight.NTSB ANC12LA061Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot’s failure to properly judge the airplane’s distance and altitude from the landing location during the final approach, which resulted in an undershoot and a nose over.NTSB CEN12CA413Accident · Serious injuriesData collectionFinal reportCessna 182K · Newark, OHThe pilot's loss of control during taxi in strong wind conditions.NTSB ERA12CA427Accident · No injuriesData collectionFinal reportCessna 182A · Sussex, NJThe pilot’s delayed decision to abort the landing and perform a go-around, which resulted in a runway overrun.NTSB CEN12CA394Accident · Minor injuriesData collectionFinal reportBoeing B75N1 · Fredricksburg, TXThe pilot's excessive brake application, leading to a noseover during the landing. Contributing to the accident was the pilot’s delay in lowering the tail after landing.NTSB WPR12CA291Accident · No injuriesData collectionFinal reportStinson 108-2 · Mile Hi Landing Strip, IDThe pilot's misjudgment of the speed and distance required to land, which resulted in a runway overrun.