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 CEN13CA272Accident · No injuriesData collectionFinal reportCessna 172M · Thief River Falls, MNThe pilot’s failure to maintain clearance from the power line while on approach to landing.NTSB ERA13CA233Accident · Minor injuriesData collectionFinal reportHughes Charles R Zodiac 601XL · Meriden, CTThe pilot's decision to land with a tailwind and his failure to maintain aircraft control during landing.NTSB CEN13CA266Accident · No injuriesData collectionFinal reportCessna 140 · Glenwood Springs, COThe pilot's failure to maintain airplane control during the landing roll and his excessive use of right brake, which resulted in a noseover.NTSB ANC13CA044Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.NTSB ERA13FA225Accident · 1 fatalField investigationFinal reportGrumman G-44 · Catskill, NYThe pilot’s misjudgment of the airplane’s altitude above the water and early flare for a landing on water with a glassy condition, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN13CA251Accident · No injuriesData collectionFinal reportAlexander Duane A RV-8 · Cortland, OHThe pilot’s failure to maintain control of the airplane after encountering an unexpected soft spot in the runway during landing.NTSB CEN13LA243Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Albuquerque, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC13CA039Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Seward, AKThe pilot’s decision to land on an unsuitable landing surface, which resulted in a nose over.NTSB WPR13CA207Accident · No injuriesData collectionFinal reportWaco YKS-7 · Rialto, CAThe pilot’s failure to maintain directional control and his improper brake usage during the landing roll in a crosswind condition.NTSB CEN13LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Bowling Green, MOThe failure of the engine supercharger's rear bearing, which resulted in the loss of engine power.NTSB ANC13CA046Accident · No injuriesData collectionFinal reportCessna U206G · Nenana, AKIce accretion in the right main landing gear wheel brake during departure, which prevented the right main landing gear from rotating on landing and resulted in a runway excursion and subsequent impact with a snow bank.NTSB CEN13CA234Accident · No injuriesData collectionFinal reportCessna 175A · Albuquerque, NMThe pilot’s inability to maintain airplane control during taxi due to an inadvertent encounter with a dust devil.NTSB ERA13CA206Accident · Minor injuriesData collectionFinal reportPoole Robert C JR Van's · Salisbury, NCThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent decision to exit the paved runway onto the soft terrain.NTSB ERA13CA207Accident · No injuriesData collectionFinal reportCessna A185F · Palatka, FLThe pilot’s failure to retract the landing gear after takeoff from a runway, and his subsequent water landing with the wheels extended.NTSB WPR13CA192Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Moose Creek Ranger Station, IDThe pilot's use of excessive braking after landing with a tailwind and after an extended touchdown to avoid deer on the runway.NTSB CEN13CA222Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot’s failure to maintain airplane control while taking off in gusting wind conditions.NTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.NTSB CEN13CA224Accident · No injuriesData collectionFinal reportAeronca 65C · Grand Rapids, MNThe student pilot’s failure to adequately lock the primer before takeoff and the flight instructor's failure to verify that the primer was adequately locked.NTSB CEN13CA203Accident · No injuriesData collectionFinal reportAviat A-1B · Dumas, TXThe pilot’s failure to maintain control of the airplane while taking off in gusty crosswind conditions. Contributing to the accident was the pilot’s decision to takeoff instead of waiting to ensure that the wind velocity had decreased.NTSB ANC13CA034Accident · No injuriesData collectionFinal reportPiper PA-16 · Big Lake, AKThe pilot's decision to land on unsuitable terrain.NTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.NTSB ERA13CA164Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Groveland, FLThe pilot's failure to maintain the proper airspeed during a tailwind approach, his improper decision to continue a fast approach with a tailwind rather than go around, and his improper use of the wheel brakes during the landing roll.NTSB ERA13LA159Accident · Minor injuriesLimited investigationFinal report781569 FX 210 · Punta Gorda, FLA total loss of engine power for reasons that could not be determined from the available evidence.NTSB ANC13LA032Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe overstress fracture and failure of the right wheel/ski arm while taxiing in snow and water-overflow terrain conditions, which resulted in a noseover.NTSB ERA13LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Naples, METhe student pilot’s improper decision to land on a frozen lake.NTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.NTSB CEN13CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · Elcho, WIThe pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.NTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.NTSB WPR13LA108Accident · No injuriesLimited investigationFinal reportCessna 175B · Wellsville, UTA loss of engine power during cruise flight due to carburetor ice.NTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.NTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.NTSB WPR13CA088Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Rialto, CAThe pilot's failure to maintain airplane control while taxiing in gusting wind conditions.NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB CEN13LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcola, TXThe loss of engine power during initial climb 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 WPR13LA063Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Billings, MTThe pilot’s inability to maintain directional control during the landing roll because of the failure of the tailwheel support bracket.NTSB ERA13LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canton, GAA partial loss of engine power due to carburetor icing, which the pilot could not correct by applying carburetor heat because the movement of the carburetor heat control arm was restricted.NTSB CEN13LA057Accident · No injuriesLimited investigationFinal reportCessna T182T · San Antonio, TXThe pilot’s misjudgment of the landing speed and the runway distance remaining and his delay in applying the brakes, which resulted in an overrun.NTSB ERA13LA052Accident · No injuriesLimited investigationFinal reportWaller Charles R Rans S12-XL · Gordon, ALA fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.NTSB CEN13CA064Accident · Minor injuriesData collectionFinal reportLawson Ron Rans S-19 · Crowley, LAThe pilot’s improper landing flare, which resulted in the collapse of the nose landing gear and the airplane nosing over.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN13LA050Accident · No injuriesLimited investigationFinal reportWaco SRE · Lafayette, LAThe pilot’s inability to maintain directional control of the airplane during the landing roll.NTSB CEN13CA042Accident · Minor injuriesData collectionFinal reportLuscombe 8E · West Bend, WIThe pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.NTSB WPR13CA033Accident · Minor injuriesData collectionFinal reportCessna 140 · Watsonville, CAThe pilot’s failure to maintain airplane control during the landing roll.NTSB CEN13CA037Accident · No injuriesData collectionFinal reportBates Starduster SA-300 · Reklaw, TXThe pilot’s improper recovery from a bounced landing, which resulted in a noseover.NTSB WPR13CA019Accident · Serious injuriesData collectionFinal reportQuicksilver Mfg MXL II Sport · Live Oak, CAThe pilot’s failure to compensate for turbulent conditions, which resulted in a loss of altitude.NTSB ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.NTSB ERA13CA047Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Plymouth, MAThe pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB CEN13LA011Accident · No injuriesLimited investigationFinal reportMeyers Little Toot · Roanoke, TXThe total loss of engine power due to partially obstructed fuel lines.NTSB ANC12LA113Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Fairbanks, AKThe pilot’s excessive application of brakes during landing, which resulted in a noseover.