NTSB investigations
2,290 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 ERA17CA149Accident · Serious injuriesData collectionFinal reportNorth American T 6G · Culpepper, VAThe pilot's failure to maintain airplane and directional control during the landing roll and subsequent go-around in gusting wind conditions.NTSB GAA17CA220Accident · No injuriesData collectionFinal reportShilt Jerry C F-1 Rocket · Bessimer, ALThe pilot’s failure to maintain directional control during the landing rollout in gusting crosswind conditions.NTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.NTSB GAA17CA199Accident · No injuriesData collectionFinal reportPiper PA 22 · Scappoose, ORThe student pilot’s loss of directional control during the landing roll and his subsequent inadvertent brake application, which resulted in a nose-over.NTSB GAA17CA219Accident · Minor injuriesData collectionFinal reportCessna 172 · Millbrook, NYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing with a crosswind, which resulted in an aerodynamic stall and an off-runway landing.NTSB GAA17CA214Accident · Minor injuriesData collectionFinal reportRonald J Bender Baking Duce · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll after encountering a dirt devil.NTSB GAA17CA210Accident · No injuriesData collectionFinal reportPiper PA22 · Soldotna, AKThe pilot’s unstabilized approach and failure to attain the proper touchdown point, which resulted in a runway overrun and collision with a snowbank.NTSB GAA17CA203Accident · No injuriesData collectionFinal reportAeronca 11AC · Warroad, MNThe pilot’s improper landing flare and his subsequent failure to maintain directional control during the landing in tailwind conditions.NTSB ERA17FA131Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Minter City, MSThe pilot's incapacitation for reasons that could not be determined, which resulted in collision with trees and terrain.NTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.NTSB GAA17CA190Accident · Minor injuriesData collectionFinal reportDavis Frank R Xenos Motorglider · Minden, NVThe pilot’s failure to maintain directional control in variable wind conditions.NTSB GAA17CA181Accident · No injuriesData collectionFinal reportAerotek Pitts S-2A · West Palm Beach, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.NTSB GAA17CA175Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot's failure to maintain directional control while taxiing in gusting crosswind conditions.NTSB GAA17CA173Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe student pilot’s loss of directional control.NTSB GAA17CA171Accident · Minor injuriesData collectionFinal reportSmith Douglas J. Sonex · Mercey Hot Springs, CAThe sport pilot’s unstabilized approach with a tailwind, which resulted in touchdown short of the runway and a subsequent nose-over.NTSB GAA17CA168Accident · Minor injuriesData collectionFinal reportMaule MX7 · Live Oak, CAThe pilot’s failure to maintain a stabilized approach and his subsequent incorrect brake application during the landing roll, which resulted in a nose-over.NTSB GAA17CA156Accident · No injuriesData collectionFinal reportCessna 120 · Orange, MAThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA17CA159Accident · No injuriesData collectionFinal reportPiper PA22 · Big Lake, AKThe contamination of snow and ice on the left main landing gear and brake, which prevented the wheel from rolling during touchdown and resulted in a nose-over.NTSB GAA17CA153Accident · No injuriesData collectionFinal reportStinson 108 · Valparaiso, INThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB GAA17CA142Accident · No injuriesData collectionFinal reportCessna T182 · Three Rivers, MIThe pilot’s failure to maintain sufficient airspeed during the landing flare, which resulted in a hard landing and a nose-over.NTSB GAA17CA144Accident · No injuriesData collectionFinal reportPitts Special S 1C · Borger, TXThe pilot’s failure to maintain directional control of the biplane during takeoff.NTSB GAA17CA141Accident · No injuriesData collectionFinal reportCessna 170 · Wheatland, WYThe flight instructor’s incorrect compensation for the gusting crosswind during the landing roll, which resulted in a loss of directional control and runway excursion.NTSB GAA17CA134Accident · No injuriesData collectionFinal reportCessna 180 · Tyonek, AKThe pilot’s improper decision to land on a snow-covered airstrip with a tundra tire-equipped airplane, which resulted in a nose-over.NTSB CEN17LA092Accident · Minor injuriesLimited investigationFinal reportZenith CH750 Stol · Jennings, LAA failure of the right fuel tank to supply fuel to the engine for reasons that could not be determined, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR17LA062Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Jiggs, NVAn engine anomaly for reasons that could not be determined, which resulted in a precautionary landing in deep snow and a subsequent noseover.NTSB GAA17CA128Accident · No injuriesData collectionFinal reportCessna 210 · Charleston, WVThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard landing and runway excursion.NTSB GAA17CA125Accident · No injuriesData collectionFinal reportGreat Lakes 2T1A · Canon City, COThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s unstabilized approach.NTSB GAA17CA133Accident · No injuriesData collectionFinal reportCessna 182 · Sebring, OHThe pilot’s failure to maintain the proper glidepath during landing, which resulted in the airplane landing short of the runway, the nose landing gear separating, and the airplane nosing over during a second landing.NTSB ERA17LA091Accident · Serious injuriesLimited investigationFinal reportAmerican Legend AL3 · Pierson, FLThe pilot's improper braking during takeoff, which resulted in a nose-over.NTSB GAA17CA115Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Bainbridge, GAThe student pilot's exceedance of the airplane’s critical angle of attack during final approach, which resulted in an aerodynamic stall, and his subsequent loss of directional control after touchdown.NTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.NTSB WPR17LA053Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Buckeye, AZThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB GAA17CA116Accident · No injuriesData collectionFinal reportCessna 170 · Coeur D'Alene, IDThe pilot’s failure to maintain an appropriate descent rate during approach, which resulted in landing short of the runway threshold.NTSB ERA17LA083Accident · Serious injuriesLimited investigationFinal reportMaule MX7 · Carthage, TNThe pilot's inadequate compensation for gusting tailwind conditions, which resulted in a loss of airplane control during the landing flare.NTSB GAA17CA110Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Milton-Freewater, ORThe pilot's decision to take off from unsuitable terrain with a tailwind, which resulted in a nose-over.NTSB GAA17CA111Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard landing.NTSB GAA17CA106Accident · Minor injuriesData collectionFinal reportMaule M7 · Palouse, WAThe pilot’s failure to maintain directional control on an ice- and snow-covered runway during taxi with a crosswind, which resulted in a runway excursion.NTSB WPR17LA042Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Willows, CAThe decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn…NTSB GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.NTSB GAA17CA099Accident · Minor injuriesData collectionFinal reportPiper PA38 · Hartford, CTThe student pilot’s improper landing flare, which resulted in a bounced hard landing.NTSB CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.NTSB CEN17LA065Accident · No injuriesLimited investigationFinal reportLueck Kitfox 7 · Cody, WYImproper maintenance of the fuel pressure regulator, which resulted in an excessive fuel and airbox pressure differential and subsequent loss of engine power.NTSB ERA17LA071Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palm Bay, FLUnknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.NTSB ERA17LA070Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Ormond Beach, FLThe pilot's impairment by alcohol before and during the flight, which led to his improper fuel management and resulted in fuel exhaustion and a subsequent loss of engine power.NTSB CEN17LA057Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ionia, MIA failure of the aft support cable on the left main landing ski due to an inadequately formed nicopress sleeve, which allowed the ski to rotate into a vertical position shortly after liftoff, and its unavoidable separation during the subsequent landing.NTSB GAA17CA087Accident · No injuriesData collectionFinal reportJack Fehling Celebrity · North Hampton, NHThe pilot’s unstabilized approach, which resulted in the biplane being low and striking trees.NTSB GAA17CA084Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Pensacola, FLThe student pilot’s incorrect brake application during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA17LA053Accident · Minor injuriesLimited investigationFinal reportBroussard Broussard MH 1521 · Simpsonville, SCThe pilot’s inability to maintain directional control during the landing roll due to a flat left main landing gear tire.