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 ATL05LA073Accident · 1 fatalLimited investigationFinal reportAnderson Mini Mustang · Mullins, SCThe pilot's inadequate visual lookout and the pilot's failure to maintain clearance from trees while maneuvering.NTSB ATL05CA074Accident · No injuriesData collectionFinal reportCessna 172H · Oakwood, GALoss of engine power due to fuel system contamination.NTSB WAS05WA010Accident · No injuriesForeign investigationSikorsky S-61 · Terengganu, MalaysiaNTSB SEA05LA076Accident · No injuriesLimited investigationFinal reportBeech A36 · Plant City, FLAn engine power interruption during takeoff for undetermined reasons.NTSB NYC05LA071Accident · No injuriesLimited investigationFinal reportBrennan Flightstar · Middleboro, MAA loss of engine power for undetermined reasons.NTSB NYC05CA072Accident · No injuriesData collectionFinal reportCessna 172B · Collegeville, PAThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident was the downdraft wind conditions.NTSB IAD05CA056Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA40 · Leesburg, VAThe pilot's failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the uphill terrain.NTSB DEN05LA069Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Englewood, COThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control during landing. Contributing factors were crosswind weather conditions and a lack of familiarity with the aircraft.NTSB CHI05CA098Accident · No injuriesData collectionFinal reportCurl Avid Air Magnum · Cando, NDThe pilot's failure to compensate for the crosswind condition and maintain directional control during landing rollout. Factors to the accident were the crosswind and the muddy drainage ditch.NTSB SEA05CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McCammon, IDA loss of engine power due to the pilot's inadequate in-flight decision/planning by failing to refuel while en route, resulting in fuel exhaustion. Factors contributing to the accident included the trees and fence.NTSB MIA05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Groveland, FLThe pilot's poorly planned approach during a precautionary landing following partial loss of engine power resulting in a go-around and subsequent in-flight collision with trees. A contributing factor in the accident was the inadequate maintenance by the…NTSB LAX05LA138Accident · No injuriesLimited investigationFinal reportCessna 150F · Prescott, AZthe pilot's failure to maintain directional control on landing.NTSB DFW05CA104Accident · Minor injuriesData collectionFinal reportBeech J35 · Bartlesville, OKA loss of engine power due to the pilot's inadvertent and improper positioning of the fuel tank selector, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB ANC05TA058Accident · Minor injuriesFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's selection of unsuitable terrain for taxi after landing, which resulted in the collapse of the main landing gear and structural damage to the right wing and forward fuselage. A factor associated with the accident was the rough and uneven terrain.NTSB ANC05CA059Accident · No injuriesData collectionFinal reportCessna U206E · Yakutat, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose down, and structural damage to the wing. A factor contributing to the accident was the soft sand.NTSB MIA05CA090Accident · No injuriesData collectionFinal reportNorth American AT-6C · Lakeland, FLThe pilot's attempted turn off the runway at excessive speed, resulting in the right wing raising, the left wing touching the runway, and the left landing gear collapsing.NTSB IAD05LA055Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Oakland, MDThe pilot's delay in aborting the landing, which resulted in an inadvertent stall/mush into the trees. A factor in the accident was the tailwind.NTSB DFW05LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Olney, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB CHI05CA100Accident · Minor injuriesData collectionFinal reportMitchell KR-2S · Cameron, MOThe loss of engine power for an undetermined reason and the misjudged landing flare which resulted in the bounced landing. Additional causes were the improper recovery from the bounced landing and the inadvertent stall. A factor was the pilot's lack of…NTSB SEA05FA075Accident · 1 fatalField investigationFinal reportRaytheon Bonanza · South Bay, FLThe pilot's failure to maintain aircraft control while in cruise flight. Factors include night conditions and flat featureless terrain.NTSB MIA05CA092Accident · No injuriesData collectionFinal reportCessna 337 B · Ocala, FLThe pilot's improper landing flare during an aborted takeoff, which resulted in a hard landing and damage to the airplane.NTSB MIA05CA091Accident · No injuriesData collectionFinal reportCessna 172 · Kissimmee, FLThe pilot's improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.NTSB LAX05LA143Accident · Serious injuriesLimited investigationFinal reportFirefly Balloon Firefly 11 · Saint Helena, CAThe pilot's encounter with wind shear during landing, which resulted in a hard touchdown.NTSB LAX05LA136Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Phoenix, AZa loss of power for undetermined reasons.NTSB LAX05LA135Accident · 1 fatalLimited investigationFinal reportCameron Balloons A-210 · Marana, AZthe failure of the flying pilot to attain a proper climb rate and maintain an adequate clearance from rising terrain. Also causal was the commercial pilot's inadequate supervision of the flight and his delayed remedial action.NTSB DFW05CA072Accident · No injuriesData collectionFinal reportRobinson R44 II · Woodward, OKthe pilot's encounter with adverse weather conditions.NTSB DEN05LA068Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Morrison, COthe pilot's failure to maintain rotor RPM during the approach which resulted in a landing short of the helipad.NTSB CHI05LA097Accident · No injuriesLimited investigationFinal reportCessna 310 · Clear Lake, MNThe collapse of the nose landing gear as a result of the pilot performing improper maintenance on the airplane due to his failure to properly safety the nose landing gear door.NTSB SEA05FA074Incident · No injuriesField investigationFinal reportCessna 208B · Roosevelt Roads, PRThe fracture of multiple compressor turbine blades while the airplane was in a cruise flight configuration resulting in a loss of engine power. Sulphidation type corrosion was a factor in failure of the blades.NTSB LAX05LA134Accident · Minor injuriesLimited investigationFinal reportNewell Thomas RV6-A · Hayward, CAA loss of engine power due to fuel system contamination. A factor in the accident was the fuel system not being flushed out after it was involved in a previous accident where the fuel tanks were damaged.NTSB LAX05CA137Accident · No injuriesData collectionFinal reportCessna 172S · Gallup, NMthe pilot's premature liftoff and inadequate remedial action, which resulted in the airplane inadvertently recontacting the runway.NTSB ENG05WA008Incident · No injuriesForeign investigationLockheed L382G (C-130) · Yellowknife NWT, CanadaNTSB DFW05LA102Accident · 2 fatalLimited investigationFinal reportSpearman Raptor · Bogalusa, LAThe pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.NTSB NYC05LA070Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Warren, PAThe pilot's failure to follow the balked landing checklist while attempting to abort a landing. Factors in the accident were his failure to maintain directional control during the landing, and a gust of wind.NTSB NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.NTSB LAX05LA133Accident · Minor injuriesLimited investigationFinal reportClark Aerosport Scamp · Chino, CAa loss of engine power due to the pilot/builder's excessive adjustment (lean) of the mixture setting at the carburetor. The pilot/builder's failure to perform a more comprehensive ground test prior to flight was a factor.NTSB SEA05LA073Accident · No injuriesLimited investigationFinal reportShorethose Kitfox Series 5 · Cresent City, FLAircraft handling not maintained during the landing rollout. Factors include soft terrain.NTSB LAX05CA147Accident · No injuriesData collectionFinal reportMaule MA-7-235C · Borrego Springs, CAthe pilot's failure to maintain directional control.NTSB IAD05LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot's improper flare, which resulted in a hard landing.NTSB IAD05CA054Accident · No injuriesData collectionFinal reportClark/Loken Christen Eagle II · South Woodstock, CTThe pilot's improper flare, which resulted in a hard landing.NTSB DFW05FA099Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Jefferson, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB CHI05LA094Accident · No injuriesLimited investigationFinal reportTschida Glastar · Kendallville, INA loss of engine power due to fuel starvation as a result of the fuel flow restriction at the internal engine fuel filter due the presence of the silicone sealant material. Contributing factors were the unsuitable terrain for a forced landing short of the…NTSB CHI05CA092Accident · No injuriesData collectionFinal reportMooney M20M · Lincoln, NEThe pilot inadvertently exceeded the design limits of the airplane during the recovery from the loss of control due to the unanticipated severe turbulence. Factors to the accident were the turbulence in clouds and the main landing gear collapse.NTSB ATL05CA072Accident · No injuriesData collectionFinal reportSchleicher ASW19b · Henderson, NCThe pilot's misjudgment of the landing area which resulted in overshooting the touchdown point. A factor was the in-flight encounter with weather (No thermal lift).NTSB ANC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control and the airplane nosing over during the landing roll.NTSB ANC05CA057Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop. A factor contributing to the accident was a tailwind.NTSB SEA05CA080Accident · No injuriesData collectionFinal reportCessna 172 · Yamhill, ORThe pilot's failure to maintain aircraft control while on final approach for landing. A crosswind, a fence post and the pilot's inadequate compensation for the crosswind condition were contributing factors.NTSB SEA05CA079Accident · Minor injuriesData collectionFinal reportCessna 150 · Independence, ORThe pilot's failure to secure the airplane while starting the engine by hand-propping.NTSB MIA05CA089Accident · Minor injuriesData collectionFinal reportAerostar Yak-52TW · Daytona Beach, FLPilot's failure to maintain directional control in a variable wind condition during landing resulting in the airplane departing the runway subsequent landing gear separation and impact with trees.NTSB LAX05LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · California City, CAThe failure of the normal landing gear system to extend for undetermined reasons that resulted in a gear collapse during landing.