NTSB investigations, GA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA' 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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' 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 ERA09LA369Accident · 2 fatalLimited investigationFinal reportP&M Quikr · Cedar Town, GAA loss of aircraft control for an undetermined reason.NTSB ERA09CA366Accident · Minor injuriesData collectionFinal reportCessna 210-5(205) · Porterdale, GAThe loss of engine power due to fuel exhaustion as a result of the pilot's use of improper fuel caps. Contributing to the accident was the pilot’s selection of an unsuitable area for landing.NTSB ERA09CA362Accident · No injuriesData collectionFinal reportCessna T206H · Columbus, GAThe pilot's improper flare, which resulted in a hard landing.NTSB ERA09IA338Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B1 · Atlanta, GAThe failure of the left main landing gear to extend due to high levels of particulate contamination in the hydraulic fluid.NTSB ERA09IA326Incident · No injuriesIncident investigationFinal reportIniziative Sky Arrow · Marietta, GAAn electrical fire due to the lack of a positive locking mechanism for the fuse retainer in the main fuse block, which resulted in voltage fluctuations that caused thermal damage to the avionics cooling fan. Contributing to the incident was the student…NTSB ERA09CA318Accident · No injuriesData collectionFinal reportPiper PA28 · Elberton, GAThe student pilot's improper recovery from a bounced landing.NTSB ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.NTSB ERA09CA268Accident · No injuriesData collectionFinal reportDiamond DA20 · Townsend, GAThe pilot's failure to maintain directional control during a landing roll with a crosswind. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09LA258Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pinehurst, GAThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB ERA09LA257Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Moultrie, GAA loss of engine power due to carburetor icing as a result of the maintenance technician's failure to detect and correct the condition of the carburetor heat duct.NTSB ERA09LA231Accident · 1 fatalLimited investigationFinal reportHoward William C KR-2 · Valdosta, GAAn in-flight fire for undetermined reasons.NTSB ERA09LA222Accident · Serious injuriesLimited investigationFinal reportRogers Kenneth J Flaglor Scooter · Griffin, GAA total loss of engine power due to the failure of the engine-driven fuel pump. Contributing to the accident was unsuitable terrain for a forced landing and the pilot’s preexisting medical condition.NTSB ERA09CA225Accident · No injuriesData collectionFinal reportCessna 150L · Brunswick, GAThe student pilot's failure to maintain aircraft control while landing in gusting crosswinds.NTSB ERA09LA224Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD88 · Atlanta, GAThe flight attendant’s failure to properly restrain herself after taking her jumpseat.NTSB ERA09LA203Accident · Serious injuriesLimited investigationFinal reportWayne O Robinson S6S Rans · Cartersville, GAThe pilot's failure to maintain airspeed following a partial loss of engine power during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was chafed wires in the ignition system.NTSB ERA09CA216Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe failure of the pilot to maintain clearance with a parked airplane.NTSB ERA09FA185Accident · 3 fatalField investigationFinal reportCessna 182P · Carrollton, GAThe pilot's decision to continue visual flight rules flight into an area of reduced visibility weather conditions, which resulted in disorientation and subsequent loss of aircraft control.NTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.NTSB ERA09CA149Accident · No injuriesData collectionFinal reportD-Fly UL Stork · Jackson, GAThe pilot's inadvertent activation of an engine cutoff switch during cruise flight.NTSB ERA09CA138Accident · No injuriesData collectionFinal reportMD Helicopter 369E · Atlanta, GAWind gusts during engine shutdown, which resulted in the main rotor blades contacting the tailboom.NTSB ERA09LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, GAA total loss of engine power for an undetermined reason.NTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB ENG09IA002Incident · No injuriesIncident investigationFinal reportBoeing 777 · Atlanta, GAThe fan blade fractured due to a fatigue crack that was the result of the combination of the breakdown of the fan blade lubrication system and residual fatigue life usage following the last overhaul of the fan blade. Contributing to the fracture was the…NTSB ERA09CA118Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Brunswick, GAThe pilot's failure to maintain control of the airplane during the landing flare. Contributing to the accident were the gusting winds.NTSB ERA09CA102Accident · Minor injuriesData collectionFinal reportPiper PA-34-200 · Folkston, GAThe student's improper flare and the flight instructor's delayed remedial action.NTSB ERA09CA038Accident · No injuriesData collectionFinal reportBeech 35-C33 · Atlanta, GAThe pilot’s failure to maintain a proper glide path during the final approach, resulting in a collision with the airport approach lights.NTSB ERA09LA050Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe failure of the nose gear drag link bolt due to reversed bending fatigue.NTSB ERA09FA005Accident · Minor injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Swainsboro, GAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ERA09LA004Accident · No injuriesLimited investigationFinal reportCessna T210M · Savannah, GAA loss of engine power in flight due to fuel exhaustion as a result of the pilot's improper fuel management.NTSB NYC08FA319Accident · 1 fatalField investigationFinal reportPiper PA-32 · Atlanta, GAA loss of aircraft control for undetermined reasons.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.NTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.NTSB NYC08CA314Accident · No injuriesData collectionFinal reportCessna 172R · Brunswick, GAThe student pilot's improper flare while landing.NTSB MIA08LA187Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlanta, GAThe loss of pitch control due to slippage of the elevator control cable resulting from the maintenance personnel’s improper installation and inspection of the cable.NTSB NYC08CA304Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Cleveland, GAThe pilot's improper approach to the runway resulting in his being unable to flare prior to a hard landing.NTSB NYC08CA283Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Cleveland, GAThe pilot's improper decision to land with a tailwind, and his failure to maintain aircraft control during the landing. Contributing to the accident was the tailwind.NTSB NYC08LA273Accident · No injuriesLimited investigationFinal reportOuzts Rodney Rutan-LongEZ · Winder, GAThe failure of the left brake due to contamination of the brake fluid.NTSB MIA08LA156Accident · Minor injuriesLimited investigationFinal reportDiamond DA-20-C1 · Peachtree City, GAA partial loss of engine power for undetermined reasons.NTSB NYC08LA258Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Atlanta, GAThe pilot's improper flare during landing.NTSB MIA08LA147Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Rome, GAThe pilot's improper landing flare which resulted in a hard landing.NTSB MIA08FA141Accident · 1 fatalField investigationFinal reportSocata TBM700 · Kennesaw, GAThe pilot’s failure to maintain airspeed during final approach resulting in an aerodynamic stall.NTSB NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.NTSB NYC08IA244Incident · No injuriesIncident investigationFinal reportAgusta A109E · Augusta, GAThe lack of available engine power and subsequent loss of rotor rpm due to the pilot’s departing with one engine at idle. Contributing to the incident was a corroded engine control wiring harness.NTSB MIA08LA133Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Colquitt, GALoss of engine power due to the installation of incorrect turbine blades on the compressor turbine disk during repair of the disk assembly.NTSB NYC08LA235Accident · 1 fatalLimited investigationFinal reportLanier James A Talon XP · Cleveland, GAAn inadvertent stall during the initial climb.NTSB MIA08CA117Accident · No injuriesData collectionFinal reportPiper J3C-65 · Fayetteville, GAThe pilot's failure to maintain control of the airplane during climbout. Contributing to the accident was the pilot's relinquish of control to a non-certificated pilot.NTSB MIA08CA104Accident · No injuriesData collectionFinal reportCessna 172M · Savannah, GAThe pilot's failure to maintain directional control on landing touchdown with a crosswind.NTSB MIA08LA106Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Hiram, GAThe failure of the starflex arm during engine run-up due to inadequate inspection by maintenance personnel.NTSB LAX08CA148Accident · No injuriesData collectionFinal reportCessna 150H · Augusta, GAThe pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.NTSB CHI08LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wrightsville, GAThe pilot's failure to maintain control during takeoff. Contributing to the accident were the gusty winds.