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 ANC05LA003Accident · No injuriesLimited investigationFinal reportScan 30 · Anchorage, AKAn in-flight fire during cruise flight for an undetermined reason.NTSB ANC05IA002Incident · No injuriesIncident investigationFinal reportBoeing MD-11F · Anchorage, AKThe operator's failure to provide sufficient weight and balance information to the flight crew, which resulted in a center of gravity aft of the limit, and a tail strike during the takeoff roll. Factors associated with the incident are the operator's improper…NTSB SEA05FA004Accident · No injuriesField investigationFinal reportMaule MT-7-420 · Bend, ORLoss of engine power during takeoff climb for undetermined reasons. Rough terrain was a factor.NTSB DFW05CA004Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-26E · El Paso, TXThe pilot's misjudgment of distance and altitude during a local soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB DEN05CA007Accident · No injuriesData collectionFinal reportMooney M20E · Broomfield, COthe pilot's improper flare and recovery from a bounced landing during a touch and go maneuver. Contributing factors were the excessive airspeed and descent rate during the approach.NTSB CHI05CA003Accident · No injuriesData collectionFinal reportSinclair Zenith 701 · Augusta, KSThe manufacturer's inadequate design/production of the landing gear axle leading to its separation and the airplanes subsequent nose over during the landing roll.. A factor was the axle's separation from its spring.NTSB ANC05LA001Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe inadequate and unapproved design of the main landing gear assembly by the manufacturer, which resulted in a failure of the main landing gear during landing, and structural damage to the airplane. A factor in the accident was the pilot's misjudged flare.NTSB IAD05LA002Accident · No injuriesLimited investigationFinal reportBradley Renegade · Stow, MAA partial loss of engine power for undetermined reasons, which resulted in the airplane's inability to climb over a stand of trees.NTSB DEN05LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Casper, WYthe student pilot's improper flare resulting in a hard landing. A factor contributing to the accident was the student pilot's improper recovery from the bounced landing.NTSB LAX05CA004Accident · No injuriesData collectionFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)the pilot's inadequate preflight inspection to ensure that all tie downs were removed from the helicopter, which resulted in a dynamic rollover.NTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.NTSB FTW05CA002Accident · No injuriesData collectionFinal reportThunder and Colt AA-1050 · Crescent, OKThe pilot's failure to maintain clearance from the high power transmission lines. Contributing factor was the dark night and high wind conditions.NTSB FTW05CA001Accident · Minor injuriesData collectionFinal reportAerostar S-60A · Austin, TXThe pilot's excessive descent rate during the execution of a high wind landing, resulting in a hard landing. A factor was the high wind.NTSB MIA05WA005Accident · 1 fatalForeign investigationPiper PA-38-112 · Rio Negro, ArgentinaNTSB FTW05LA003Accident · Minor injuriesLimited investigationFinal reportLockheed 18-56 · Midland, TXThe pilot's failure to maintain directional control during takeoff. Contributing factors were the choice of runway used and the prevailing tailwind.NTSB DEN05LA004Accident · Serious injuriesLimited investigationFinal reportWorner Balloon Works NL-1000 · Chama, NMthe lightning strike and subsequent failure of the balloon's envelope, resulting in an uncontrolled descent and impact with terrain.NTSB DEN05FA003Accident · 1 fatalField investigationFinal reportCessna A185E · Luna, NMthe pilot's improper use of the mixture control, his failure to maintain clearance from the trees, and his improper preflight planning resulting in his taking off into a canyon and subsequently impacting the trees and terrain. Factors contributing to the…NTSB CHI05CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marion, IAThe pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.NTSB CHI05CA001Accident · Serious injuriesData collectionFinal reportPiper PA-23-180 · Beatrice, NEThe loss of right engine power undetermined reasons. Factors to the accident were the loss of engine power at a low altitude and below the single engine best rate of climb airspeed (Vyse), and the unsuitable terrain encountered during the subsequent forced…NTSB SEA05LA008Accident · No injuriesLimited investigationFinal reportHiggins Acro-Sport II · Coeur d'Alene, IDThe airplane's wood propeller separated from the airplane during cruise. A factor was the ditch that the airplane impacted during the landing roll subsequent to the forced landing.NTSB SEA05LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Augusta, MTThe pilot's failure to maintain adequate obstacle clearance which resulted in the in-flight collision with rising terrain. Trees and rising terrain are factors in the accident.NTSB SEA05CA003Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Medford, ORThe pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.NTSB MIA05CA002Accident · Minor injuriesData collectionFinal reportRobinson R-22 · Pompano Beach, FLThe flight crew's excessive descent rate during landing, resulting in a hard landing, and the tail boom being severed.NTSB LAX05LA002Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Sedona, AZa loss of engine power due to the fatigue fracture of the number 7 cylinder exhaust rocker arm as a result of a grinding operation during manufacture.NTSB LAX05CA001Accident · No injuriesData collectionFinal reportCessna TU206A · Nogales, AZthe pilot's failure to remain on the designated taxiway surface, which resulted in the airplane's collision with the ditch. The dark lighting condition was a factor to the accident.NTSB IAD05LA001Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Robbinsville, NJThe repair station's improper installation of the stabilator trim tab. A factor was the pilot's inadequate preflight inspection of the airplane.NTSB DEN05FA002Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Santa Fe, NMthe pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…NTSB ATL05LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Ashland, ALA total loss of engine power in cruise flight due to the fatigue failure of the No.4 cylinder exhaust valve.NTSB MIA05LA001Accident · No injuriesLimited investigationFinal reportRotorway 162F · New Smyrna Beac, FLA loss of engine power due to undetermined reasons, which resulted in the pilot entering autorotation and affecting a forced landing to the water.NTSB DEN05CA001Accident · No injuriesData collectionFinal reportCessna 185F · Santa Fe, NMthe pilot's failure to maintain aircraft control during the landing roll resulting in a ground loop. Contributing to the accident was the crosswind.NTSB DEN04LA150Accident · No injuriesLimited investigationFinal reportCessna 172S · Broomfield, COthe pilot's improper flare, and the flight instructor's inadequate supervision of the pilot.NTSB CHI04LA292Accident · No injuriesLimited investigationFinal reportCessna 150M · Durand, MIThe elongated exhaust valve leading to the in-flight loss of engine power during initial climb. A factor was the transmission wire the airplane impacted during its emergency landing after takeoff.NTSB CHI04FA290Accident · 3 fatalField investigationFinal reportBeech B95A · Burlington, WIThe improper maintenance of the fuel servo resulting in a loose adjustment nut and subsequent failure of the fuel injection servo which led to a complete loss of power on the right engine. Other causes were the pilot's failure to obtain or maintain minimum…NTSB ATL04CA197Accident · No injuriesData collectionFinal reportCessna 150M · Sevierville, TNThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with high vegetation and a subsequent nose over. Factors were a foggy windshield and windshield defrost not activated.NTSB NYC04FA220Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Avondale, PAThe pilot's inadequate preflight inspection that resulted in fuel contamination and a subsequent loss of engine power.NTSB MIA04LA134Accident · Serious injuriesLimited investigationFinal reportBoeing 767-232 · Caribbean SeaAn inadvertent encounter with severe turbulence during cruise, which resulted in a flight attendant being injured.NTSB MIA04LA133Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-27 · Vega Baja, PRThe pilot's improper inflight planning which resulted in an inflight encounter with weather (low ceilings and thunderstorms), his loss of aircraft control, and an inflight collision with the ocean during uncontrolled descent.NTSB MIA04LA132Accident · No injuriesLimited investigationFinal reportBell 206L · Gulf of MexicoA loss of engine power for undetermined reasons while on short final to land on an oil platform in the Gulf of Mexico, which resulted in the pilot ditching the helicopter into the water.NTSB CHI04LA298Accident · No injuriesLimited investigationFinal reportCessna 208B · Decatur, ILThe pilot's inadequate preflight preparation, and his subsequent selection of a runway for takeoff that was listed as out of service, resulting in a collision with barricades and uneven terrain during takeoff.NTSB CHI04LA285Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Perham, MNThe dual student's improper compensation for the crosswind condition and his subsequent failure to maintain control of the airplane. An additional cause was the flight instructor's inadequate remedial action. A contributing factor was the crosswind condition.NTSB CHI04CA289Accident · No injuriesData collectionFinal reportArganbright Vans RV-4 · Custer, SDThe pilot's failure to maintain directional control during the landing. Factors were the sudden wind shift and the embankment.NTSB CHI04CA286Accident · No injuriesData collectionFinal reportCessna C-150J · Oxford, IAThe student pilot's failure to attain a proper glidepath which resulted in exceeding the proper touchdown point. An additional cause was his failure to abort the landing. The embankment was a factor.NTSB ATL04LA195Accident · 2 fatalLimited investigationFinal reportCessna 172L · Gadsden, ALThe flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.NTSB ATL04CA196Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Charlotte, NCThe pilot's misjudgment of speed and distance resulting in an overrun and collision with trees.NTSB ANC04CA119Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Haines, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a premature liftoff and subsequent uncontrolled descent and collision with the runway.NTSB LAX04CA332Accident · No injuriesData collectionFinal reportBell 222U · Santa Rosa, CAthe pilot-in-command's (examinee's) incorrect collective control response to a simulated power loss of the number 1 engine.NTSB FTW04CA246Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe failure of a piston connecting rod for undetermined reasons resulting in the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04CA245Accident · No injuriesData collectionFinal reportCessna 172H · Houston, TXThe student pilot's failure to maintain clearance from a parked aircraft while taxiing. A contributing factor was the student pilot's anxiety attack.NTSB DEN04LA149Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS-350-B3 · Las Cruces, NMThe pilot's failure to maintain aircraft control during takeoff resulting in the helicopter's skid striking the helipad and the helicopter's subsequent rollover. Factors contributing to the accident were the pilot's improper preflight planning/decision, his…NTSB ANC04CA116Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Talkeetna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was tundra.