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 LAX04CA214Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's improper application of brakes during the landing roll, resulting in a nose over.NTSB ATL04CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Cedartown, GAThe pilot's improper use of brakes during landing roll which resulted in the airplane nosing over.NTSB FTW04LA086Accident · No injuriesLimited investigationFinal reportLake LA4-270T · Crowley, LAThe pilot's inadvertant water landing with the landing gear extended. Contributing factors were the sunglare and the pilot's failure to verify the position of the flaps and landing gear.NTSB NYC04LA046Accident · No injuriesLimited investigationFinal reportCessna 172E · Islip, NYThe pilot's failure to maintain aircraft control, which resulted in a nose over. A factor in this accident was the gusty wind conditions.NTSB ANC03CA110Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Eagle, AKThe pilot's selection of an unsuitable landing area, and his excessive use of the airplane's brakes during the landing roll, resulting in a nose over. A factor associated with the accident was rough and uneven terrain.NTSB CHI03LA275Accident · No injuriesLimited investigationFinal reportCessna 170 · Neche, NDThe unsuitable terrain encountered during the precautionary landing. Contributing factors to the accident include the pilot becoming lost/disoriented, his decision to perform a precautionary landing, and the soft terrain encountered during landing.NTSB SEA03LA171Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Emmett, IDThe pilot's failure to adequately compensate for a quartering tailwind during the initial part of the landing roll, and his failure to adequately decrease his brake applications to compensate for the tailwind conditions. Factors include, variable, gusting…NTSB ANC03CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground encounter with soft terrain and subsequent nose over of the airplane. A factor associated with the accident was soft terrain.NTSB CHI03LA162Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · West Bend, WIThe pilot's excessive braking during landing roll. Contributing factors to this accident were the pilot's lack of experience in the accident airplane.NTSB ANC03LA058Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Anchorage, AKThe pilot's excessive application of the brakes during the landing roll of a short field landing, which resulted in the airplane nosing over.NTSB MIA03CA113Accident · Minor injuriesData collectionFinal reportCessna 120 · Plant City, FLThe failure of the pilot to maintain control of the airplane resulting in it nosing over during the landing roll.NTSB LAX03LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Twentynine Palm, CAThe pilot's inadequate compensation and his failure to maintain aircraft control. The gusty wind condition was a contributing factor.NTSB ANC03LA046Accident · Minor injuriesLimited investigationFinal reportAviat A1 · Anchorage, AKThe flight instructor's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB SEA03LA044Accident · No injuriesLimited investigationFinal reportCessna 180 A · Malin, ORAircraft control not maintained during landing. Soft terrain was a factor.NTSB SEA03LA039Accident · No injuriesLimited investigationFinal reportKesterson Nieuport 11 · Independence, ORAircraft control not maintained during takeoff. Factors include soft/muddy terrain.NTSB CHI03LA068Accident · No injuriesLimited investigationFinal reportCessna 182F · Estherville, IAThe pilot failed to maintain adequate control of the airplane while taxiing in high wind conditions. A factor was the high winds.NTSB CHI03LA026Accident · Minor injuriesLimited investigationFinal reportA Pair of Jacks RV-6A · Belton, MOThe punctured nose landing gear tire.NTSB ANC03LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fairbanks, AKThe pilot's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.NTSB IAD03LA009Accident · No injuriesLimited investigationFinal reportCessna 185 · Waterville, METhe pilot's excessive braking during the landing roll, which resulted in a nose over. A factor was the quartering tailwind.NTSB ANC03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Wasilla, AKThe instructor's inadequate supervision of the pilot-rated dual student, and the dual student's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.NTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.NTSB SEA02LA178Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anacortes, WANormal braking application was excessive during the landing roll resulting in the aircraft nosing over.NTSB LAX02LA260Accident · No injuriesLimited investigationFinal reportCessna 195 · Willows, CAthe pilot's inadequate compensation for crosswind conditions resulting in his failure to maintain runway alignment. Contributing factors to the accident were the pilot's lack of familiarity with the airplane.NTSB SEA02LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Shearer, IDThe pilot's failure to maintain the proper approach speed while on final approach to the 2000 foot airstrip, and his excessive application of brakes while attempting to stop the aircraft during the resultant longer than normal landing roll. Factors include a…NTSB CHI02LA204Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Farmington, MOThe locked brake and the aircraft control not being possible due to the locked brake.NTSB SEA02LA127Accident · No injuriesLimited investigationFinal reportBredl Fokker DR1 · Troutdale, ORThe collapse, for undetermined reasons, of the left main landing gear spoked-wheel structure.NTSB ANC02LA063Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Kotzebue, AKThe pilot's excessive braking action while landing on a sandbar, which resulted in a nose over.NTSB ANC02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Chugiak, AKThe pilot's excessive braking, which resulted in a noseover during landing. Factors associated with the accident were the pilot's improper touchdown point, and landing with a tailwind.NTSB CHI02LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Redfield, SDthe failure of the pilot to maintain directional control while taxing to takeoff in high and gusty wind conditions.NTSB FTW02LA111Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARThe inadequate supervision by the flight instructor of the pilot who was receiving instruction resulting in the excessive application of the brakes during the landing roll resulting in a nose over. A factor was the gusty crosswind conditions.NTSB CHI02LA098Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Russell, KSThe pilot failed to maintain control of the airplane during the back-taxi. Additional factors were the tailwind and the wind gust.NTSB SEA02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · NAS Whidbey, WAThe pilot's improper decision to taxi behind a standing large military turbo-prop aircraft, which he knew may be performing periodic engine test runs, without first initiating communications to insure that the engine power on the standing aircraft would…NTSB SEA02LA052Accident · No injuriesLimited investigationFinal reportSkystar Kitfox Lite Squared · Caldwell, IDThe pilot's failure to adequately compensate for the wind conditions. High and gusting winds were a factor.NTSB LAX02LA099Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Marana, AZThe left brake failed due to a stuck piston.NTSB LAX02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beatty, NVThe pilot failed to maintain control of the airplane.NTSB SEA02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Pacific City, ORThe pilot's inadequate compensation for local wind conditions during the landing roll. Factors include unfavorable winds, and a swampy area adjacent to the runway.NTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.NTSB SEA02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle Point, ORThe pilot inadvertently failed to retract the landing gear for the water landing and the aircraft nosed over.NTSB SEA02LA021Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Ashland, ORThe pilot's excessive use of brakes. A factor was the pilot's lack of recent experience in type of aircraft.NTSB ATL02LA018Accident · No injuriesLimited investigationFinal reportPitts S-1S · Sanford, FLThe pilot's failure to maintain control of the airplane during landing roll in a tailwind, which resulted in a nose-over on the runway.NTSB CHI02LA029Accident · No injuriesLimited investigationFinal reportSchenfield Acro Sport II · Keosauqua, IAAircraft control not maintained by pilot during landing.NTSB IAD02LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Millbrook, NYpilot's inadvertent activation of the right brake during landing roll-out , which caused the airplane to nose over. A factor was the crosswind.NTSB NYC02LA031Accident · No injuriesLimited investigationFinal reportMaule M7-260 · North Lima, OHThe pilot's failure to retract the landing gear, which resulted in a wheels down landing on water.NTSB CHI02LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Bellaire, MIthe unsuitable terrain for landing selected by the pilot. A factor was the soft terrain.NTSB MIA02LA007Accident · No injuriesLimited investigationFinal reportCessna A150L · Buena Vista, GAThe pilot's failure to use proper bounced landing technique, resulting in a hard touchdown, propeller strike, and noseover.NTSB NYC01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kenton, OHThe pilot's failure to stop the airplane within the available runway. Factors included the uneven braking and the pilot's lack of experience in airplane make and model.NTSB SEA01LA162Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Shelton, WAThe binding/grabbing of the right main gear braking system during the landing roll.NTSB SEA01LA156Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Twin Falls, IDNose over during the landing roll for undetermined reasons.NTSB ANC01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe pilot's excessive use of brakes during the landing roll.NTSB ANC01LA092Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Skwentna, AKThe pilot's excessive use of brakes during the landing roll.