NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 ANC92LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Cinnibar, AKThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.NTSB ANC92LA123Accident · No injuriesLimited investigationFinal reportBeech C99 · Nuiqsut, AKThe pilot's improper inflight planning/preparation, and his failure to attain the proper touchdown point. Contributing to the accident was the downdraft.NTSB NYC92LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Baltimore, MDA power loss due to fuel starvation from a faulty rubber seal in the mechanical fuel pump while operating over unsuitable terrain. An additional cause was the use of inadequate standards for the production of the rubber seal.NTSB NYC92LA148Accident · Minor injuriesLimited investigationFinal reportBeech 24R · Eliot, METhe pilot allowed the airspeed to get excessive, resulting in the airplane touching down too long and too fast.NTSB NYC92FA153Accident · 2 fatalField investigationFinal reportDanny M Damron Long EZ · Front Royal, VAThe pilot's self induced pressure to complete the flight which resulted in intentional flight into IMC conditions, and a collision with trees. Factors related to the accident were the pilot's over confidence in his abilities, and the low clouds and fog which…NTSB NYC92FA150Accident · 1 fatalField investigationFinal reportCessna 340 · Falmouth, KYThe improper decision by the non-instrument-rated pilot to attempt VFR flight into instrument meteorological conditions resulting in a loss of airplane control and subsequent inadvertent spiral and collision with the ground. Factors related to the accident…NTSB LAX92LA339Accident · No injuriesLimited investigationFinal reportBeech D17S · Bishop, CAThe pilot's failure to maintain directional control; improper use of the rudder and excessive braking. Contributing to this accident was the pilot's lack of experience in the accident airplane make and model.NTSB LAX92LA337Accident · 2 fatalLimited investigationFinal reportCessna 310M · Honolulu, HILoss of aircraft control for an undetermined reason after the pilot took off at night and flew the aircraft into the area of a thunderstorm and lightning.NTSB FTW92LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Nevada, TXThe PIL0T'S inadvertent stall of the airplane during the forced landing and his failure to refuel the airplane en route.NTSB FTW92DRA04Accident · Serious injuriesFinal reportEvans VP-1 · Friendswood, TXThe pilot's failure to maintain a proper descent rate during the forced landing. A factor was the engine power loss for undetermined reasons.NTSB CHI92LA235Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Paul, MNThe pilot's inattentiveness and improper use of the airplanes brakes. A factor which contributed to this accident was the incorrect brake system installed on the airplane.NTSB CHI92LA234Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Pinecreek, MNThe pilot-in-command's failure to obtain a proper climb rate.NTSB ANC92LA129Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's improper inflight planning/decision, and his failure to perform a go around. Contributing to the accident was the rough/uneven terrain.NTSB ANC92LA122Accident · Minor injuriesLimited investigationFinal reportCessna 207A · St. Michael, AKThe pilot attempted VFR flight into IMC weather conditions. Contributing to the accident were the mountainous/hilly terrain, and the low ceiling weather condition.NTSB ANC92LA121Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCS12-D · Sitka, AKThe pilots failure to maintain directional control of the airplane. Contributing to the accident were the crosswind and the large boulders (objects) beside the runway.NTSB NYC92LA144Accident · Minor injuriesLimited investigationFinal reportJohn Mitchell Myers Special · Franklin, PAThe pilot inadvertently porpoised the airplane during the landing and improper recovery from a bounced landing. A factor in this accident was the pilot's lack of experience in this type of aircraft.NTSB NYC92GA147Accident · Serious injuriesFinal reportSikorsky S-76A · Graefenburg, KYAn inadequate preflight inspection by the flight crew by failing to assure that all four of the engine cowling latches were properly secured, which resulted in subsequent failure of section ii of the tail rotor driveshaft after the cowling contacted the main…NTSB MIA92LA161Accident · Minor injuriesLimited investigationFinal reportBacon Questair Venture LX · Boca Raton, FLThe inadequate inspection/service of the nose gear acuator by other maintenance personnel causing the contamination and subsequent failure.NTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.NTSB CHI92LA236Accident · Minor injuriesLimited investigationFinal reportRockwell 112TC · Winner, SDFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.NTSB CHI92FA231Accident · 2 fatalField investigationFinal reportCessna 120 · Maple, WIThe non-instrument rated private pilot's failure to maintain aircraft control.NTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.NTSB ANC92LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Ketchikan, AKThe pilot in command/instructor pilot failed to maintain directional control of the airplane during the ground run.NTSB NYC92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Farmington, MDThe pilot's improper level off which resulted in a hard landing. Contributing was an inadeuate recovery from a bounced landing, and the pilot's lack of total flight experience.NTSB NYC92LA145Accident · Minor injuriesLimited investigationFinal reportJohn K. Groff JR. Q-2 · Caldwell, NJThe failure of the pilot to monitor his fuel supply which resulted in the power loss. A factor in the accident was unsuitable terrain.NTSB LAX92LA336Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · San Francisco, CAThe improper installation of the towbar. Contributing to the accident was a disconnected tow bar during push back.NTSB FTW92LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Killeen, TXLoss of engine power due to a fractured number three cylinder exhaust push rod assembly.NTSB FTW92LA203Accident · No injuriesLimited investigationFinal reportCessna 310I · Bridgeport, TXStudent pilot's failure to maintain directional control and improper supervision by the instructor pilot.NTSB FTW92DPG13Accident · 1 fatalFinal reportCessna A188 · Forrest City, ARThe pilot's failure to maintain clearance with the trees.NTSB CHI92LA237Accident · No injuriesLimited investigationFinal reportBeech C90 · Pontiac, MIThe pilot's not understanding the fuel system, and his subsequent inadvertent discontinuance of fuel to both engines.NTSB CHI92LA229Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenwood, NEThe private pilot's poor in-flight planning and decision making.NTSB CHI92LA226Accident · Serious injuriesLimited investigationFinal reportCessna 175A · East Lansing, MIThe pilot's inadequate preflight inspection of the aircraft which resulted in a loss of engine power during cruise flight. Related factors are the loose oil filler cap, and the short, wet grass strip used for the emergency landing.NTSB CHI92DEC03Accident · 1 fatalFinal reportJarrell RV-3 · Jackson, MIAn overload and total failure of the rear wing attach fitting.NTSB ANC92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the unfavorable wind, the trees, and the fence.NTSB ANC92LA124Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Talarik Creek, AKThe pilot selected unsuitable terrain on which operate.NTSB ANC92LA119Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Funter Pass, AKThe pilots inadequate visual lookout, and his inadvertent VFR flight into IMC conditions. Contributing to the accident were the clouds.NTSB NYC92LA143Accident · No injuriesLimited investigationFinal reportPitts S-1S · Galion, OHThe pilot's failure to maintain directional control after landing and the subsequent loss of airplane control.NTSB NYC92LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot diverted his attention from flying the airplane and did not maintain a visual lookout, which resulted in a collision with trees.NTSB LAX92TL#15Accident · No injuriesClass 3Final reportHughes 269C · Sacramento, CANTSB LAX92T#A14Accident · No injuriesClass 3Final reportBell 206-L3 · Van Nuys, CANTSB LAX92LA335Accident · Serious injuriesLimited investigationFinal reportErcoupe 415C · Dunsmuir, CAThe pilot's failure to perform any preflight planning or preparation and selected the wrong runway. Factors relating to this accident was the existing tailwind, high density altitude.NTSB LAX92LA333Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Pacific Ocean (Pacific Ocean)The pilot's inadequate preflight inspection by failing to untie the front skid tiedown rope.NTSB FTW92FA202Accident · 1 fatalField investigationFinal reportBeech C35 · Leslie, ARPilot attempted VFR flight into IMC. Factors were fog, mountainous terrain, and the pilot's lack of instrument experience.NTSB DEN92LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Littleton, COInadvertent stall during final approach to landing.NTSB DEN92LA082Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Del Norte, COInadvertent stall while maneuvering during aerial application at an altitude insufficient for recovery.NTSB DEN92FA083Accident · 1 fatalField investigationFinal reportBeech A36 · Camden, ARAn inflight breakup of the aircraft when the pilot flew into a level three thunderstorm.NTSB DEN92FA081Accident · No injuriesField investigationFinal reportCessna 402A · Holyoke, COFailure of the pilot to feather the failed engine propeller. A factor was: power loss for undetermined reasons.NTSB CHI92LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Xenia, ILImproper engine overhaul and noncompliance with an airworthiness directive by other maintenance personnel.NTSB SEA92LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paul, IDThe pilot's selection of unsuitable terrain. The soft terrain was a factor.NTSB SEA92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Farmington, UTThe pilot's poor inflight decision. Factors include downdrafts and a box canyon.