NTSB investigations
19,222 cases where NTSB found Aircraft.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 WPR17FA200Accident · 2 fatalField investigationFinal reportRaytheon G36 · Benicia, CAThe pilot's failure to maintain adequate airspeed which caused the airplane to exceed its critical angle of attack and led to an aerodynamic stall.NTSB GAA17CA535Accident · No injuriesData collectionFinal reportMooney M20J · Whitesburg, GAThe pilot’s unstabilized approach while landing with a tailwind and his subsequent failure to go around, which resulted in a hard landing.NTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB CEN17LA351Accident · No injuriesLimited investigationFinal reportCessna 340 · McKinney, TXThe failure of the bell crank pivot bolt which resulted in the left main landing gear collapse. Contributing to the accident was the lack of landing gear inspections in accordance with the airplane manufacturer's maintenance manuals.NTSB CEN17LA344Accident · No injuriesLimited investigationFinal reportAviat A 1B · Prairie du Chien, WIThe fatigue failure of the aileron hinge bracket tubing for reasons that could not be determined based on the available evidence.NTSB CEN17CA345Accident · No injuriesData collectionFinal reportShiner RV-4 · Ramah, NMThe pilot’s failure to maintain clearance from berms during landing in sun glare conditions.NTSB ERA17MA316Accident · 4 fatalClass 2 · MajorFinal reportEurocopter Deutschland MBB BK 117 · Hertford, NCA failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…NTSB ERA17FA317Accident · 2 fatalField investigationFinal reportSchweizer 269C · Medford, NJThe pilot's early entry into and failure to maintain rotor rpm during a forced landing autorotation after performing an engine shutdown in flight, which resulted in an uncontrolled descent. Contributing to the accident was the failure of maintenance personnel…NTSB WPR17FA196Accident · 1 fatalField investigationFinal reportCessna 172N · Bolinas, CAThe non-instrument rated private pilot's improper decision to embark on a flight and continue to fly into forecasted instrument meteorological conditions and mountain obscuration while conducting a visual flight rules flight.NTSB GAA17CA529Accident · Minor injuriesData collectionFinal reportCessna 182 · Fairfield, MTThe pilot's failure to secure the right fuel cap during the preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB GAA17CA523Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Redgranite, WIThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA567Accident · No injuriesData collectionFinal reportChancey Gerry M RV-12 · Dunkirk, NYThe pilot's failure to maintain lateral/bank control during takeoff in crosswind conditions.NTSB GAA17CA527Accident · No injuriesData collectionFinal reportPiper PA 12 · Kotzebue, AKThe pilot’s failure to maintain directional control while landing on an unimproved airstrip in gusting wind conditions.NTSB GAA17CA522Accident · No injuriesData collectionFinal reportLuscombe 8 · Westminster, TXThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ENG17IA036Incident · No injuriesIncident investigationFinal reportBoeing 757 232 · Las Vegas, NVA No. 1 (left) engine undercowl fire caused by a fuel nozzle installation error during engine overhaul at Delta TechOps. A fuel nozzle b-nut was cross threaded, which allowed fuel to leak on hot engine case surfaces and subsequently ignite.NTSB WPR17LA201Accident · No injuriesLimited investigationFinal reportCobalt Aircraft Industries Co50 Valkyrie · Atwater, CAA loss of aileron effectiveness due to the airplane's design configuration, which resulted in the pilot's inability to control the roll axis and led to a hard landing.NTSB GAA17CA521Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot’s failure to maintain an appropriate glidepath to an off-airport landing site.NTSB ERA17FA313Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Jacksonburg, WVThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions in the vicinity of adverse weather conditions.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 GAA17CA517Accident · No injuriesData collectionFinal reportJeff Jardine Kitfox S7 Supersport · Kanab, UTThe pilot's failure to maintain directional control during landing and the airplane’s subsequent failure to attain a climb rate during an attempted go-around in high-density altitude conditions.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 ERA17LA311Accident · No injuriesLimited investigationFinal reportPiper PA32R · Merritt Island, FLThe pilot's inadequate preflight planning and improper takeoff technique, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB WPR17LA195Accident · 1 fatalLimited investigationFinal reportWalker Edgar E Glastar · Cascade, IDThe pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…NTSB GAA17CA577Accident · No injuriesData collectionFinal reportFlight Design Ctls · Newport, RIThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA17CA545Accident · No injuriesData collectionFinal reportDedeaux Gary G GN-1 · Elba, ALThe pilot's incorrect pitch control during the initial climb, which resulted in his decision to abort the takeoff and a subsequent hard landing.NTSB GAA17CA518Accident · No injuriesData collectionFinal reportCroft Robert C Kitfox Super Sport · Afton, WYThe pilot’s failure to maintain bank control during an attempted go-around.NTSB GAA17CA516Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZThe student pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll.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 CEN17LA336Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Burnet, TXThe pilot's inadequate inflight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC17LA051Accident · No injuriesClass 3 · LimitedFinal reportLeonardo AW139 · Tujunga, CAA yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…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 ERA17LA306Accident · No injuriesLimited investigationFinal reportKerr Gerald Velocity SUV · St. Petersburg, FLThe pilot's misjudgment of the airplane’s speed and the distance remaining during landing and his improper decision to not abort the landing.NTSB ERA17LA305Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369 · Lawrenceville, GAThe pilot's inadequate compensation for wind conditions during the approach to landing, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB CEN17LA340Accident · No injuriesLimited investigationFinal reportCessna 310G · Broomfield, COA collapse of the right main landing gear due to a bent pushrod, which precluded the gear from fully extending. The reason for the bent pushrod could not be determined based on the available information.NTSB GAA17CA542Accident · No injuriesData collectionFinal reportCessna 150 · Wasilla, AKThe student pilot’s inadequate in-flight fuel planning, which resulted in fuel exhaustion, the subsequent total loss of engine power, and a forced off-airport landing.NTSB CEN17FA334Accident · 1 fatalField investigationFinal reportVans RV-12 · Fishers, INThe pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.NTSB WPR17LA193Accident · No injuriesLimited investigationFinal reportCessna 140 · Empire, NVThe pilot's failure to maintain directional control during an off-airport precautionary landing on a dirt road with an uphill gradient.NTSB GAA17CA576Accident · Minor injuriesData collectionFinal reportHunter George RV 6 · Montgomery, NYThe pilot’s loss of directional control during the takeoff roll, which resulted in impact with visual approach slope indicator lights.NTSB GAA17CA570Accident · No injuriesData collectionFinal reportPiper PA 31 · SaipanImpact with multiple birds while retracting the landing gear, which resulted in the subsequent failure of the right inboard main landing gear door actuator hose and prevented the pilot from being able to extend the landing gear.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 ERA17FA299Accident · 2 fatalField investigationFinal reportGrumman AA1 · Portland, TNThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR17LA190Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Lake Havasu City, AZThe pilot's incorrect positioning of the fuel tank selector valve during a tank switch, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the worn condition of the fuel selector valve handle position detents and…NTSB WPR17IA189Incident · No injuriesClass 3 · IncidentFinal reportCessna 560XL · San Jose, CAThe mechanic’s incorrect installation of the right main landing gear (MLG) aft trunnion pivot pin, which resulted in the pin separating from the trunnion, the trunnion puncturing the right wing, and the right MLG collapsing.NTSB GAA17CA514Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Sacramento, CAThe student pilot’s failure to maintain yaw control and the flight instructor’s delayed remedial action.NTSB GAA17CA512Accident · No injuriesData collectionFinal reportAviat A 1 · Cody, WYThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17LA302Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Harvest, ALThe pilot's improper decision to not stop and refuel the airplane as planned and his improper in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA333Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA 5B · Carbondale, ILThe failure of the propeller due to fatigue as a result of improper installation by unknown maintenance personnel at some point during the life of the propeller.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 CEN17FA331Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Ellabell, GAThe total loss of engine power due to oil starvation to the No. 1 connecting rod, which resulted from the improper torque of the No. 1 cylinder hold-down bolts and through-studs at the time of the cylinder's installation, which resulted in the failure of the…NTSB GAA17CA558Accident · No injuriesData collectionFinal reportBellanca 14 19 · Redding, CAThe pilot’s failure to maintain directional control during the landing roll.