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 GAA17CA569Accident · No injuriesData collectionFinal reportPiper PA 18 · Beluga, AKThe pilot’s inability to maintain pitch control due to an encounter with a tailwind gust after the airplane had stopped, which resulted in a nose-over.NTSB GAA17CA550Accident · No injuriesData collectionFinal reportCessna 180 · Danbury, CTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA554Accident · Minor injuriesData collectionFinal reportThomas J Murray Kitfox Super Sport · Old Forge, NYThe separation of the wheel assembly during landing due to the pilot’s use of improper retaining nuts when he installed the tundra tires.NTSB GAA17CA552Accident · No injuriesData collectionFinal reportHencken William Pietenpol AIR Camper · Franklin, PAThe failure of the weld that connects the left main landing gear and the axle during the takeoff roll.NTSB GAA17CA544Accident · No injuriesData collectionFinal reportPiper PA 11 · Petersville, AKThe pilot’s overapplication of brakes, which resulted in a nose-over.NTSB GAA17CA531Accident · No injuriesData collectionFinal reportCessna 210 · Kinsley, KSThe pilot's decision to continue an unstabilized approach for landing in tailwind conditions, which resulted in a runway overrun and a nose-over.NTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.NTSB GAA17CA525Accident · No injuriesData collectionFinal reportCessna 182 · Lockwood, MOThe pilot’s unstabilized approach and failure to go around, which resulted in a runway overrun on a wet, grass runway.NTSB GAA17CA524Accident · Minor injuriesData collectionFinal reportBoeing A75N1(PT17) · Oshkosh, WIThe pilot’s overapplication of the brakes, which resulted in the biplane coming to rest inverted.NTSB CEN17LA338Accident · No injuriesLimited investigationFinal reportGolden Eagle Chief · Mt. Zion, ILA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA515Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Winnemucca, NVThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent loss of airplane control during an attempted aborted landing.NTSB ERA17LA307Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206 · Harpswell, MEA total loss of engine power due to maintenance personnel's failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1, 2, and 3 main bearings, loss of lubrication, and failure of the crankshaft.NTSB GAA17CA513Accident · Minor injuriesData collectionFinal reportCessna 172 · Belle Fourche, SDThe flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB CEN17FA332Accident · Serious injuriesField investigationFinal reportCessna 180J · Gaylord, MIThe pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.NTSB ERA17LA298Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Wurtsboro, NYA fatigue fracture of the left main landing gear axle.NTSB WPR17LA192Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Klamath Falls, ORThe pilot's failure to follow the pre-takeoff checklist and the failure of the left main landing gear brake due to a damaged brake master cylinder piston rod, which resulted in a stuck left brake and subsequent loss of control during the landing roll.NTSB GAA17CA507Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Hillsboro, ORThe student pilot’s failure to maintain airplane control while landing in crosswind conditions and the flight instructor’s delayed remedial action.NTSB CEN17LA330Accident · No injuriesLimited investigationFinal reportAir Tractor AT 401 · Pearsall, TXThe fatigue crack of an engine cylinder, which resulted in a partial loss of engine power.NTSB GAA17CA537Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Foley, ALThe ground crew’s incorrect hook up of the banner, which resulted in a nose-over.NTSB GAA17CA496Accident · Minor injuriesData collectionFinal reportMIke Reed Super Cub · Murphy, IDThe pilot’s use of excessive brake pressure during the landing roll, which resulted in a nose-over.NTSB GAA17CA504Accident · No injuriesData collectionFinal reportBoeing E75 · Centerville, TNThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action.NTSB GAA17CA501Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s use of excessive braking during the landing roll, which resulted in a nose-over.NTSB GAA17CA493Accident · No injuriesData collectionFinal reportBoyd Bruce RV4 · Yerington, NVThe pilot's improper landing flare, which resulted in a bounded landing and subsequent loss of directional control.NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.NTSB GAA17CA471Accident · No injuriesData collectionFinal reportChampion 7ACA · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s use of excessive braking, which led to a nose-over.NTSB GAA17CA475Accident · No injuriesData collectionFinal reportCessna 180 · Willow, AKThe pilot’s improper landing flare while landing on water with glassy water conditions, which resulted in the airplane nosing over.NTSB GAA17CA473Accident · No injuriesData collectionFinal reportCessna 180 · Puntilla, AKThe airplane’s encounter with a downdraft while maneuvering at a low altitude, which resulted in the exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.NTSB CEN17LA295Accident · Minor injuriesLimited investigationFinal reportSteele Acro Sport II · Loudonville, OHA partial loss of engine power due to carburetor icing.NTSB WPR17LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Enumclaw, WAThe pilot's improper approach for landing, which resulted in the airplane landing long, and his delayed decision to go around with insufficient runway remaining, which resulted in collision with an airport perimeter fence.NTSB GAA17CA480Accident · No injuriesData collectionFinal reportThomas J Hankamp VAN'S Aircraft RV4 · Poughkeepsie, NYThe pilot’s failure to maintain directional control during takeoff.NTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.NTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA441Accident · No injuriesData collectionFinal reportPiper PA18S · Sterling, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB GAA17CA440Accident · No injuriesData collectionFinal reportMitchell Derryle V Rans S 7 Courier · Cordova, AKThe pilot’s improper decision to take off from a lake in gusting wind conditions, which resulted in a loss of airplane control.NTSB GAA17CA435Accident · No injuriesData collectionFinal reportGilbert Thomas Jeffrey Lancair 235 · Denison, TXThe pilot’s failure to maintain directional control during the takeoff roll.NTSB GAA17CA433Accident · No injuriesData collectionFinal reportStinson SR9 · Bode, IAThe pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.NTSB GAA17CA428Accident · Minor injuriesData collectionFinal reportPiper L 21B · Cartersville, GAThe pilot’s loss of directional control during the landing roll and subsequent excessive brake application, which resulted in a nose-over.NTSB ERA17LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Tamarac, FLThe flight instructor's failure to ensure that the airplane's fuel system was free of water contamination before departing, which resulted in a total loss of engine power and subsequent forced landing.NTSB GAA17CA424Accident · Minor injuriesData collectionFinal reportSalerno Kenneth G JR Kitfox Series 7 · Owyhee, ORThe pilot's failure to maintain directional control during takeoff from a rough, dirt airstrip.NTSB GAA17CA420Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2008 · Lone Rock, WIThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control and runway excursion during the aborted landing. Contributing to the improper landing flare was the student’s distraction by a deer…NTSB GAA17CA416Accident · No injuriesData collectionFinal reportPiper PA 22 · Breckenridge, MIThe pilot’s loss of situational awareness during the approach over a corn field, which resulted in collision with corn stalks.NTSB ANC17LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Wasilla, AKThe pilot’s failure to manage fuel quantity in flight, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow manufacturer guidance for restoring engine power after emptying a fuel…NTSB GAA17CA422Accident · No injuriesData collectionFinal reportPiper PA32 · Marion, IAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17CA236Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Lake Ashby, FLThe pilot's incorrect configuration of the landing gear for a water landing in an amphibious airplane, which resulted in a nose-over.NTSB GAA17CA397Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Ahoskie, NCThe pilot's failure to maintain proper lateral/bank control during the landing in gusting wind conditions, which resulted in a nose-over into water.NTSB ERA17LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cape Coral, FLA total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.NTSB ERA17TA233Accident · No injuriesFinal reportLawrence O Nolte Zodiac CH650B · Dover, PAA total loss of engine power as a result of the loss of all electric fuel pumps due to a loss of electric power because of the installation of an improper battery on the airplane and the use of improper charging cables on the battery.NTSB GAA17CA391Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Ferguson, FLThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.