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 LAX04CA224Accident · No injuriesData collectionFinal reportCessna 177B · Grand Canyon, AZthe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control.NTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.NTSB FTW04LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Levelland, TXThe student pilot's failure to maintain directional control and his inadequate compensation for the winds.NTSB DEN04LA083Accident · No injuriesLimited investigationFinal reportAyres S-2R · Beaver, UTthe in-flight failure of the engine's P3 tube which resulted in the loss of engine power and the subsequent impact with terrain during a forced landing. Contributing factors include the lack of suitable terrain for a forced landing and the fence.NTSB CHI04LA129Accident · 3 fatalLimited investigationFinal reportHall Lancair IV-P · Vermontville, MIThe failure of Air Route Traffic Control Center controllers to provide adverse weather avoidance assistance as required by FAA directives, which led to the airplane's encounter with a thunderstorm and subsequent loss of control. Contributing to the accident…NTSB ATL04LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St. Marys, GAThe pilot failure to use carburetor heat when weather condition were favorable for the for the formation of carburetor ice. .NTSB ANC04IA058Incident · Minor injuriesIncident investigationFinal reportBoeing 757-251 · Anchorage, AKThe failure of the flight attendant to follow the appropriate door opening procedure by remaining clear of the door handle when the passenger door was opened from the outside by customer service personnel, which resulted in a wrist injury to the flight…NTSB LAX04WA234Accident · 1 fatalForeign investigationRobinson R22 Mariner · Queensland, AustraliaNTSB LAX04LA230Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Rosa, CAMaintenance personnel's improper installation and servicing of a retaining ring, which resulted in the failure of the landing gear door actuator and failure of the landing gear extension system during landing.NTSB LAX04LA227Accident · No injuriesLimited investigationFinal reportBeech A36 · Hollister, CAthe pilot's inadequate preflight inspection which failed to detect the mis-rigged elevator trim system, and the pilot's delay in aborting the takeoff.NTSB ATL04LA123Accident · 1 fatalLimited investigationFinal reportCessna 310 · N. Myrtle Beach, SCThe pilot's inadequate preflight/planning and his in-flight decision which resulted in the loss of power in one engine due to fuel starvation.NTSB SEA04LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Vernonia, ORThe instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.NTSB SEA04LA094Accident · No injuriesLimited investigationFinal reportBeech P-35 · Havre, MTA loss of engine power due to fuel starvation during the initial climb after takeoff as a result of an unsecured fuel sender unit which resulted in a false fuel quantity indication.NTSB NYC04CA135Accident · No injuriesData collectionFinal reportMooney M20R · Warren, VTThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the wind shear as reported by the pilot.NTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.NTSB MIA04WA093Accident · No injuriesForeign investigationPiper PA-32-301 · Walkers Cay, BahamasNTSB MIA04CA091Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Carthage, MSThe failure of the student pilot to maintain control of the airplane resulting in the airplane departing the runway and impacting with terrain. A factor related to this accident was the student pilot's lack of total flight experience.NTSB LAX04LA229Accident · No injuriesLimited investigationFinal reportSimmons BD-5 · Goodyear, AZThe overheating and failure of the number 4 connecting rod, which resulted in a total loss of engine power during descent.NTSB FTW04LA155Accident · No injuriesLimited investigationFinal reportSchreder HP-11A · Cherry Valley, ARThe pilot's improper flare which resulted in a stall and hard landing.NTSB FTW04FA144Accident · 2 fatalField investigationFinal reportAviat A-1 · Harwood, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB DEN04LA082Accident · No injuriesLimited investigationFinal reportLockheed TV-2 · Calhan, COthe failure of the fuel tank float which resulted in the draining of fuel out the vents, and a low fuel supply. Contributing factors include the insufficient runway length, the ditch, and the rough, uneven terrain.NTSB CHI04LA131Accident · 1 fatalLimited investigationFinal reportZorn EAA Sport Bi-Plane · Mazon, ILThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the pilot's unfamiliarity with the handling characteristics of the airplane.NTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…NTSB ANC04LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and subsequent structural damage to the airplane when it struck the runway.NTSB MIA04CA090Accident · No injuriesData collectionFinal reportCaproni Vizzola Cos. Aero. A-21 · Starkville, MSThe pilot's inadequate preflight planning and preparation and his delayed decision to return to the airport leading to an off airport landing as a result of deteriorating weather conditions. A finding in the investigation was the windshield that fogged up.NTSB LAX04LA228Accident · Minor injuriesLimited investigationFinal reportWilson Avid Bandit · Paso Robles, CAthe loss of engine power during takeoff climb due to a cold seizure of the rear cylinder.NTSB FTW04FA143Accident · Minor injuriesField investigationFinal reportEurocopter AS355N · League City, TX"This case was modified may 30, 2006." The pilot's misjudged flare during an autorotation, which resulted in a hard landing and subsequent rollover.NTSB CHI04GA130Accident · 1 fatalFinal reportCessna T206H · Homer Glen, ILThe seized turbocharger, the altitude/clearance not maintained/obtained during approach to a forced landing on an agricultural field, and the unsuitable landing area encountered by the pilot. Contributing factors were the inadequate emergency procedures by…NTSB WAS06WA016Accident · Minor injuriesForeign investigationCessna A185F · Pontianak, IndonesiaNTSB NYC04LA133Accident · Serious injuriesLimited investigationFinal reportMosher Avid Heavy Hauler · Fitchburg, MAThe malfunction of the elevator control system, resulting in a forced landing.NTSB MIA04WA089Accident · 3 fatalForeign investigationCessna 210B · Marsh Harbour, BahamasNTSB FTW04LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Cleveland, TXThe in-flight fire that resulted from an electrical arc in the main battery cable near the main power bus. The cause of the arcing event could not be determined.NTSB DCA04MA049Accident · No injuriesMajor investigationFinal reportRaytheon Corporate Jets 390 Premier I · North Las Vegas, NVThe flight's unstabilized approach and excessive speed. Contributing to the excessive touchdown speed was the presence of a tailwind at landing.NTSB FTW04CA141Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Tarzan, TXThe pilot's failure to maintain proper airspeed suitable for flight. Contributing factors were the high density altitude and tail wind condition.NTSB FTW04CA140Accident · Minor injuriesData collectionFinal reportBeech BE-58P · Oklahoma City, OKThe pilot's failure to attain the proper touchdown point of the runway. Contributing factors were the excessive airspeed and the pilot's failure to initiate a go-around.NTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…NTSB CHI04LA127Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Near St. Louis, MOThe unexpected encounter with convective turbulence which resulted in a flight attendant being injured.NTSB CHI04CA142Accident · No injuriesData collectionFinal reportKauffman Bede IV · Acme, MIEngine oil starvation and inadequate maintenance by the pilot.NTSB ANC04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot/owner's failure to ensure that the airplane was in an airworthy condition prior to flight, which resulted in a partial loss of engine power and subsequent in-flight collision with a residence during an emergency landing after takeoff. Factors…NTSB NYC04CA131Accident · No injuriesData collectionFinal reportCessna 120 · New Castle, PAThe pilot's failure to use all available takeoff area and his delay in aborting the takeoff.NTSB LAX04TA264Accident · No injuriesFinal reportBell 212HP · Chester, CAthe pilot's excessive use of the cyclic and collective controls in response to the helicopter's unexpected rocking motion, which led to a main rotor contact with the upper wire cutter mounted on the cabin roof. A factor in the accident was the rough, sloping…NTSB DEN04FA078Accident · 1 fatalField investigationFinal reportAir Borne Windsports Pty. Edge Wing X · Carter, WYThe non-certificated pilot's failure to maintain adequate airspeed resulting in a stall. Factors contributing to the accident include the non-certificated pilot's improper judgment and the his lack of experience.NTSB DEN04CA080Accident · No injuriesData collectionFinal reportCessna T188C · Lamar, COA partial loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the low altitude.NTSB SEA04LA092Accident · Serious injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Creswell, ORThe pilot's failure to maintain clearance from the terrain while attempting to maneuver the aircraft into the wind during an off-airport landing in an open field. Factors include the pilot's inadequate in flight planning, tailwind conditions during an…NTSB NYC04FA127Accident · 1 fatalField investigationFinal reportMooney M20J · Oxford, CTThe pilot's failure to maintain altitude/clearance during an instrument approach, which resulted in a collision with trees prior to the runway. Factors were nighttime conditions and cloud cover.NTSB LAX04CA220Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Sparks, NVthe student pilot's misjudged altitude, distance, and speed, and failure to attain the proper touchdown point, resulting in an overshoot of the runway.NTSB FTW04LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Decatur, TXThe student pilot's failure to follow the flight instructor's instructions and relinquish the controls, and the flight instructor's delay in initiating a go-around.NTSB FTW04CA139Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Beedeville, ARThe pilot's failure to maintain directional control of the airplane during landing roll-out. Contributing factors were the crosswind and condition of the the runway.NTSB DEN04FA074Accident · 2 fatalField investigationFinal reportPiper PA-30 · Evanston, WYthe pilot's failure to maintain terrain clearance. Contributing factors include snow, low ceiling, icing conditions, and the dark night.NTSB ATL04LA122Accident · Serious injuriesLimited investigationFinal reportQuicksilver GT-500 · Cleveland, GAThe student pilot's failure to maintain directional control and his inadequate compensation for wind during takeoff. A factor was crosswind condition.