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 MIA06LA126Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Navarre, FLThe inadequate manufacturing of the plates of the tail rotor tension-torsion bar assembly resulting in fatigue failure.NTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.NTSB LAX06FA200Accident · 2 fatalField investigationFinal reportCessna 152 · Peoria, AZthe failure of both the flight instructor and student pilot to regain control of the airplane in a timely manner during an intentional spin maneuver, resulting in a collision with terrain. A factor in the accident was the instructor's inadequate supervision…NTSB LAX06CA199Accident · No injuriesData collectionFinal reportMooney M20K · Fresno, CAThe pilot's improper flare and his inadequate recovery from a bounced landing that resulted in a porpoise.NTSB DFW06CA156Accident · Minor injuriesData collectionFinal reportCampbell W/Smiley J Execytive 162F · Porter, TXThe pilot's loss of control after encountering dynamic rollover while hovering.NTSB DCA06WA065Incident · No injuriesForeign investigationBoeing B737-400 · Frankfurt, GermanyNTSB CHI06LA161Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · New York, NYThe foreign object damage to the horizontal stabilizer during taxi as a result of improper airport maintenance by contract maintenance personnel. The aluminum plate was a factor.NTSB CHI06FA152Accident · 1 fatalField investigationFinal reportBeech B36TC · Gregory, MIThe non-mechanical loss of engine power for undetermined reasons during cruise flight and the unsuitable terrain the pilot selected for the forced landing. A factor was the tree that was impacted during the forced landing. An additional factor was the…NTSB ATL06LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nashville, TNImproper installation of the fuel line by maintenance personnel which resulted in the fuel line disconnecting and a loss of engine power during approach.NTSB NYC06WA170Accident · No injuriesForeign investigationRobinson R-22 · Paris, FranceNTSB LAX06LA196Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carson City, NVFuel exhaustion which resulted in a loss of engine power during approach for landing due to the pilot's failure to refuel the aircraft and the pilot's failure to perform an adequate preflight inspection.NTSB LAX06FA197Accident · 2 fatalField investigationFinal reportBeech H35 · Reno, NVLoss of engine power during takeoff initial climb for undetermined reasons, which resulted in a loss of control and impact with a house. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DCA06WA049Accident · No injuriesForeign investigationBoeing 747-200 · Rio Negro, ColombiaNTSB SEA06LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Ennis, MTThe loss of engine power during takeoff due to an excessively lean fuel-to-air mixture ratio as a result of excessive mating surface wear between the mixture control arm and metering shaft. A factor was the improper installation of the new engine, which…NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.NTSB NYC06IA143Incident · No injuriesIncident investigationFinal reportCessna 172S · Lawrence, MAForeign object damage to the leading edge of the propeller blade, which resulted in fatigue cracking and subsequent blade failure.NTSB NYC06CA140Accident · No injuriesData collectionFinal reportCessna A185E · Turner, METhe pilot's failure to obtain the proper touchdown point, resulting in a runway undershoot, and substantial damage to the airplane.NTSB DFW06LA154Accident · No injuriesLimited investigationFinal reportMcClung Christian Eagle I · Pocahontas, ARThe loss of engine power as a result of a fractured crankshaft due to fatigue. A factor was the engine modifications to increase engine horsepower.NTSB DFW06IA151Incident · Serious injuriesIncident investigationFinal reportBell 206L-1 · South Pass 57 (Gulf of Mexico)The passenger's failure to follow procedures associated with operations in the vicinity of the helicopter and his failure to see/avoid the tail rotor of the helicopter.NTSB DFW06CA155Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Minturn, ARThe pilot's inadequate inflight planning/decision, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06TA148Accident · Minor injuriesFinal reportSchweizer 269C · Schererville, INThe pilot's improper autorotation following an actual loss of engine power during a practice autorotation, which resulted in a hard landing. A factor associated with the accident was the loss of engine power at the beginning of the practice autorotation for…NTSB CHI06LA150Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Darmstadt, INThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control, and an on-ground collision with terrain.NTSB CHI06CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Jackson, MIThe pilot's inadvertent wheels up landing.NTSB ATL06CA089Accident · Minor injuriesData collectionFinal reportMooney M20M · Banner Elk, NCThe pilot's failure to attain the proper touchdown point during landing.NTSB NYC06LA139Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Du Bois, PAThe pilot's inadequate compensation for wind conditions, which resulted in a stall and subsequent impact with the ground. A factor was the wind gust as reported by the pilot.NTSB LAX06WA201Accident · No injuriesForeign investigationBell 407 · Bangalore, IndiaNTSB SEA06LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Park Valley, UTIncapacitation of the pilot secondary to a myocardial infarction. A ditch was a contributing factor.NTSB SEA06CA111Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · American Falls, IDThe pilot's performance of low altitude flight and his failure to maintain clearance with a power line, which resulted in an in-flight collision with the power line.NTSB LAX06LA192Accident · No injuriesLimited investigationFinal reportCessna 180A · Marina, CAthe installation of the unapproved forward seat stop by unknown maintenance personnel, which did not allow for full depth engagement of the seat lock pin, resulting in the seat slipping aft during the takeoff roll and subsequent loss of directional control. A…NTSB LAX06CA191Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Alpine, CAa loss of engine power due to the aviation maintenance technician's failure to install the correct oil sump quick drain, which resulted in the inadvertent draining of engine oil during flight.NTSB DEN06CA082Accident · No injuriesData collectionFinal reportCessna 182R · Albuquerque, NMthe pilot's failure to maintain directional control of the airplane after landing.NTSB DCA06RA042Accident · No injuriesForeign investigationMcDonnell Douglas DC10-10F · Managua, NicaraguaNTSB ANC06LA069Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Jacksonville, FLAn undetermined event during takeoff/initial climb, which resulted in an emergency landing after takeoff and substantial damage to the airplane.NTSB SEA06CA136Accident · No injuriesData collectionFinal reportCessna 206G · Stanley, IDThe pilot's failure to maintain directional control during an aborted takeoff. Factors include a tailwind gust, and a large rock near the side of the runway.NTSB NYC06FA138Accident · Minor injuriesField investigationFinal reportDornier DO-328-300 · Manassas, VAThe partially blocked pitot system, which resulted in an inaccurate airspeed indicator display, and an overrun during an aborted takeoff. A factor associated with the accident was the pilot-in-command's delayed decision to abort the takeoff.NTSB LAX06LA190Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Antioch, CAThe loss of oil pressure due to metal pieces from the number 5 piston skirt in the oil system, which prevented the oil valve top ball valve from seating. The muddy terrain was a factor.NTSB LAX06CA193Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Gualala, CAthe pilot's misjudged distance and speed, which resulted in a runway overrun. A contributing factor was the hump in the runway.NTSB LAX06CA189Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Llano, CAthe student pilot's failure to recover from a porpoise/pilot induced oscillation, which resulted in a hard landing.NTSB DFW06CA152Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Victoria, TXThe pilot's delay in aborting the takeoff which resulted in an overrun. A contributing factor was the unfavorable wind.NTSB CHI06LA146Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Faribault, MNDirectional control not obtained/maintained by the pilot during landing. A contributing factor was the ditch.NTSB ANC06LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Birchwood, AKThe pilot's improper servicing/adjustment of the main landing gear brakes, which resulted in a locked brake and a loss of control while taxiing.NTSB SEA06LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Laurel, MTThe failure of maintenance personnel to properly reinstall the left-hand control yoke to the left-hand control column, and the failure of other maintenance personnel to properly verify the installation, which resulted in the pilot's loss of control in flight…NTSB SEA06CA117Accident · No injuriesData collectionFinal reportAyres S-2R · Grand View, IDThe pilot's inadvertent reduction of turbine engine power to the reverse position while landing on a desert road. A factor was the fence adjacent to the road.NTSB NYC06LA136Accident · 1 fatalLimited investigationFinal reportHowe/Wilmer Lancair 360 · Montgomery, NYA loss of control during approach for undetermined reasons.NTSB NYC06FA137Accident · 2 fatalField investigationFinal reportGates Learjet 35A · Groton, CTThe crew's failure to properly monitor the airplane's altitude, which resulted in the captain's inadvertent descent of the airplane into water. Contributing to the accident were the foggy weather conditions, and the captain's decision to descend below the…NTSB LAX06CA194Accident · No injuriesData collectionFinal reportCessna T207A · Jean, NVthe pilot's failure to obtain and maintain an adequate airspeed, which resulted in a stall/mush. A factor in the accident was the high density altitude.NTSB ENG06IA018Incident · No injuriesIncident investigationFinal reportBoeing 767-223(ER) · Los Angeles, CAThe HPT stage 1 disk failed from an intergranular fatigue crack because of GE's inadequate design of the CF6-80 series HPT stage 1 disk. The inadequate design of the disk resulted in a high stress area in the blade slot bottom aft corner that was at or nearly…NTSB DFW06CA153Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Mena, ARThe pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB DFW06CA150Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Alex, OKThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.NTSB CHI06LA147Accident · Minor injuriesLimited investigationFinal reportAllied Ag Cat Productions G-164A · Gonvick, MNThe aborted takeoff not performed by the pilot. A contributing factor is the reported loss of takeoff performance.