NTSB investigations
665 cases where the first occurrence was “Nose over”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 300) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 300) 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 ANC95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's selection of unsuitable terrain for landing/taxi. Factors associated with the accident were the soft and snow covered terrain.NTSB ANC95LA007Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of unsuitable terrain for landing. Snow covered terrain in the landing area was a factor in the accident.NTSB CHI95LA010Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Mt. Horeb, WIthe pilot's excessive braking while taxiing from landing.NTSB FTW94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Galena, AKThe pilot's excessive use of brakes during landing. A factor was the unfavorable winds at the remote landing area.NTSB FTW94LA307Accident · No injuriesLimited investigationFinal reportCessna 140 · Nenana, AKThe pilot's excessive use of the brakes during the aborted takeoff.NTSB LAX94LA343Accident · No injuriesLimited investigationFinal reportCessna 195 · Palo Alto, CAthe pilot's improper use of the airplane's brakes during the landing rollout.NTSB ANC94LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selecting a gravel bar for a normal landing. A factor was the soft spot in the gravel bar.NTSB SEA94LA222Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Caldwell, IDThe jamming of the right main landing gear brake due to an accumulation of a gummy deposit.NTSB SEA94LA224Accident · No injuriesLimited investigationFinal reportCessna 206 · Bliss, IDThe pilot's failure to maintain directional control. Factors include sunglare from the setting sun, and the soft terrain along the side the runway.NTSB LAX94LA328Accident · No injuriesLimited investigationFinal reportCessna 180 · Sedona, AZthe pilot's inadvertant application of wheel brakes during a critical phase of landing rollout.NTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.NTSB CHI94LA278Accident · No injuriesLimited investigationFinal reportCessna 120 · Manitowoc, WIthe private pilot's improper use of brakes during the landing roll. A related factor is his lack of total experience.NTSB ATL94LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vanceboro, NCThe pilot's improper use of wheel brakes.NTSB ANC94LA092Accident · No injuriesLimited investigationFinal reportCessna A185F · Anchorage, AKThe pilot misjudged the landing flare. A factor in the accident was the glassy water.NTSB LAX94LA294Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Ligurta, AZThe pilot's failure to assure the suitability of the landing area prior to the flight. The dark night and the badger hole were factors in the accident.NTSB ATL94LA145Accident · No injuriesLimited investigationFinal reportChampion 7-GCBC · Hartford, ALThe pilot's improper use of the wheel brakes.NTSB ANC94LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Newtok, AKThe pilot's selection of unsuitable terrain.NTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.NTSB ANC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's excessive use of the wheel brakes.NTSB LAX94LA238Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Valencia, CAthe pilot's selection of an unsuitable field for an off-airport landing and attempted takeoff.NTSB FTW94LA163Accident · No injuriesLimited investigationFinal reportGulfstream G-164C · Weiner, ARThe pilot selected unsuitable terrain for the takeoff.NTSB LAX94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe pilot's improper use of the brakes.NTSB MIA94LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · Crescent City, FLThe pilot's improper descent rate, and the check pilot's inadequate supervision. The glassy water condition was a factor.NTSB LAX94LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beowawe, NVthe pilot's inadvertent application of the brakes combined with excessive forward control pressure during recovery from a bounced landing.NTSB MIA94LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Parkland, FLImproper planning/decision by the director of operations, and failure of the instructor pilot to take adequate remedial action. A factor related to the accident was: the soft/wet runway condition.NTSB CHI94LA118Accident · No injuriesLimited investigationFinal reportCessna TU206B · Canton, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB CHI94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Benton, ILThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the tailwind.NTSB LAX94LA137Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Carlsbad, CAThe pilot's failure to follow the correct procedures when he released the parking brake. The inadvertently engaged parking brake and the outdated flight manual were factors in this accident.NTSB LAX94LA110Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe cfi's inproper supervision of the flight, the dual student's improper recovery from a bounced landing, and the dual student's improper use of the brakes. The cfi's lack of total instructional experience is a factor in this accident.NTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.NTSB SEA94LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Cheyenne, WYThe pilot's poor in flight decision. Factors include high winds, gusts, and the pilot's lack of total experience operating in high wind conditions.NTSB SEA94LA025Accident · No injuriesLimited investigationFinal reportCessna T210F · Sheridan, WYThe pilot did not obtain proper assistance after landing in high wing conditions. Factors contributing to the accident were the strong, gusty wind conditions.NTSB SEA94LA006Accident · No injuriesLimited investigationFinal reportCessna 177A · La Sal, UTThe pilot in command's failure to abort the takeoff. Factors contributing to the accident were the high (10,000 foot) density altitude and the fence.NTSB SEA93LA203Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Recluse, WYThe brake system locked for undetermined reasons.NTSB LAX93LA344Accident · No injuriesLimited investigationFinal reportCessna 182A · Potrero, CAThe overload failure of the upper nose gear torque link and the subsequent separation of the nose wheel and fork assembly from the nose gear strut. A factor in the accident was the surface irregularity in the dirt landing strip.NTSB ANC93LA169Accident · No injuriesLimited investigationFinal reportCessna 180 · Sweet Lucy Lake, AKThe pilot in command's improper preflight planning and decision making. A factor in the accident was the high wind conditions.NTSB ANC93LA141Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bernard Glacier, AKImproper planning/decision by the pilot, concerning the landing at the remote strip, which resulted in a nose over, while using heavy brakes to stop. A factor related to the accident was: the rough/uneven condition of the landing strip.NTSB ANC93LA135Accident · No injuriesLimited investigationFinal reportLuscombe SL8 · Dillingham, AKThe pilot-in-command's selection of unsuitable terrain for landing. A factor was the soft terrain.NTSB ATL93LA141Accident · No injuriesLimited investigationFinal reportCessna 150F · Wilmington, NCA hidden soft spot on the runway that resulted in a nose over of the airplane during a landing roll.NTSB CHI93LA263Accident · No injuriesLimited investigationFinal reportGrumman G164B · Wyndmere, NDthe pilot's decision to land on unsuitable terrain. Factors in the accident are the wet and soft turf runway.NTSB ANC93LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Uganik River, AKPilot in commands failure to compensate adequately for shifting wind conditions and his selection of unsuitable terrain on which to land. A factor in the accident was the rough uneven terrain landing strip.NTSB ANC93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot in command selected unsuitable terrain on which to land on. A factor in the accident was the rough/uneven, soft terrain.NTSB FTW93LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dumas, ARThe pilot's inadequate compensation for wind conditions.NTSB ANC93LA082Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Skwentna, AKThe pilot in command not maintaining directional control of the airplane. A factor in the accident was the gusty wind condition.NTSB CHI93FA180Accident · 1 fatalField investigationFinal reportBeech C-18S · North Branch, MNexcessive use of brakes by the pilot-in-command.NTSB ATL93LA094Accident · No injuriesLimited investigationFinal reportBellanca GC-BC · Panama City, FLThe failure of the pilot to maintain control of the aircraft and his poor inflight decision to attempt a downwind landing at the 975 foot airfield. A factor was the tail wind condition which existed at the airfield at the timeNTSB ANC93LA063Accident · No injuriesLimited investigationFinal reportCessna 206 · Deadhorse, AKThe pilot's poor judgment in attempting to land under the existing high wind condition.NTSB CHI93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot's selection of unsuitable terrain on which to land and his excessive use of brakes.NTSB MIA93LA108Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Lakeland, FLThe excessive application of brakes during the landing roll by the PIC. Contributing to the accident was his diverted attention while observing a flagman near the runway.NTSB NYC93LA083Accident · No injuriesLimited investigationFinal reportRobinson R22B · Ronkonkoma, NYThe lack of adequate supervision and delayed remedial action by the flight instructor. A factor related to the accident was the delay in adding power by the student pilot which resulted in a low rotor RPM condition.