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 SEA05CA142Accident · No injuriesData collectionFinal reportBeech H-35 · Oregon City, ORThe unattended animal on the runway during the landing, which caused the pilot to pull up and land a second time, resulting in an overrun. A factor contributing to the accident was the inability to abort the landing due to obstacles at the end of the runway.NTSB LAX05GA231Accident · 2 fatalFinal reportEurocopter France EC120B · Fair Oaks, CAThe failure of the constant delta P diaphragm in the fuel control unit, which resulted in an increased fuel flow and subsequent catastrophic failure of the engine. The diaphragm's failure was the result of improper installation by the engine manufacturer. A…NTSB LAX05CA235Accident · No injuriesData collectionFinal reportCessna T210M · TwentyninePalms, CAthe pilot's failure to verify the current local wind condition that resulted in his selection of the wrong runway and an inadvertent downwind landing, a runway overrun and a ground collision with objects. A factor in the accident was the short runway and its…NTSB LAX05CA233Accident · Minor injuriesData collectionFinal reportCessna 170B · Prescott, AZthe pilot's misjudged flare, and excessive use of the elevator control, which resulted in a failure to maintain adequate airspeed and a stall/mush.NTSB DFW05LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Bonita, LAThe failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.NTSB DFW05CA181Accident · No injuriesData collectionFinal reportMesserschmitt BK-117 B-2 · Houston, TXThe separation of the left passenger door due to worn attaching hardware.NTSB DEN05LA118Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Englewood, COthe pilot not maintaining clearance from the portable helipad during taxi after landing resulting in the airplane colliding with it. Factors contributing to the accident were the pilot's selection of a taxi route through a non-movement area, his inability to…NTSB CHI05FA192Accident · No injuriesField investigationFinal reportAerospatiale AS365N · Valparaiso, INThe loose tail rotor drive shaft coupling due to its improper installation by the operator's maintenance personnel, which resulted in the failure of the tail rotor drive shaft. An additional cause was the inability of the pilot to maintain control of the…NTSB CHI05CA185Accident · Minor injuriesData collectionFinal reportAero Commander S2R · Walnut, ILFuel exhaustion due to the pilot's inadequate in-flight planning/decision. A contributing factor was the corn field.NTSB CHI05CA184Accident · Minor injuriesData collectionFinal reportHirsch RV-6A · Oshkosh, WIThe pilot's failure to maintain directional control during the takeoff. Contributing factors were the uneven (rough) runway surface and the fence.NTSB CHI05LA186Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOA loss of engine power for undetermined reasons during the intentional autorotation. The pilot's misjudgment of the touchdown flare leading to a hard landing was an additional cause. A contributing factor was the intentional autorotation.NTSB ATL05CA130Accident · Minor injuriesData collectionFinal reportJabiru SK0007 · Aiken, SCThe loss of engine power for undetermined reasons.NTSB NYC05LA119Accident · No injuriesLimited investigationFinal reportPratt Ultravia Pelican-PL · Middlebury, VTA partial loss of engine power for undetermined reasons.NTSB MIA05CA134Accident · No injuriesData collectionFinal reportBell 206B · San Juan, PRThe inadequate preflight/planning by the pilot for his initiation of the flight with inadequate fuel supply, and his failure to maintain main rotor rpm following a total loss of engine power due to fuel exhaustion which resulted in a hard landing.NTSB LAX05FA229Accident · No injuriesField investigationFinal reportEurocopter AS350BA · Kapaau, HIthe in-flight separation of the tail rotor system as a result of a loss of clamp force and fatigue fracturing of the attachment nut plates. The cause of the loss of clamp force was likely due to an inadvertent tail rotor blade strike during the previous…NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.NTSB CHI05CA183Accident · Serious injuriesData collectionFinal reportRockwell S-2R · Guelph, NDThe pilot's failure to maintain clearance to the guy wire during the agricultural application pass. Contributing factors were the guy wire, and low altitude flight.NTSB IAD05LA101Accident · No injuriesLimited investigationFinal reportAeronca 65CA · Cadiz, OHCarburetor icing, which resulted in a partial loss of engine power. A factor was an unanticipated hill in the forced landing rollout area.NTSB DFW05LA180Accident · No injuriesLimited investigationFinal reportBell 430 · Gulf of MexicoThe helicopter's tail rotor blade's contact with an unknown object during landing.NTSB DCA05MA083Accident · Serious injuriesMajor investigationFinal reportBoeing 767-232 · Raleigh-Durham, NCAn inadvertent in-flight encounter with clear air turbulence.NTSB NYC05LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Elyria, OHA loss of engine power during initial climb, as reported by the pilot, for an undetermined reason which resulted in a collision with trees.NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.NTSB IAD05CA100Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Altoona, PAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with a hangar.NTSB CHI05WA182Accident · 2 fatalForeign investigationWaco UPF-7 · Moose Jaw, CanadaNTSB ATL05FA128Accident · 1 fatalField investigationFinal reportCessna 172N · Penrose, NCA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to use the full length of the runway for takeoff, and the inadvertent stall.NTSB LAX05WA234Accident · 2 fatalForeign investigationRobinson R44 · Derrybrien, IrelandNTSB DEN05LA108Accident · No injuriesLimited investigationFinal reportGrob G103 · Moriarty, NMthe glider pilot's intentional tow release at too low an altitude when he erroneously perceived the tow plane was about to crash. A contributing factor was the unsuitable terrain on which to make a landing.NTSB DEN05LA106Accident · Serious injuriesLimited investigationFinal reportClarke YAK 3UR 2000 · Heber City, UTloss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…NTSB DEN05CA107Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Roosevelt, UTthe pilot's failure to maintain control of the aircraft during landing. A factor contributing to the accident was the crosswind.NTSB CHI05LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · La Gygne, KSThe failure of the throttle control cable which resulted from wear followed by fatigue cracking. A factor associated with the accident was the corn crop which the airplane contacted during the forced landing.NTSB CHI05LA177Accident · Serious injuriesLimited investigationFinal reportNorth American P-51D · Tarkio, MOA loss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.NTSB ATL05LA126Accident · 1 fatalLimited investigationFinal reportEllsworth Sky Bolt · Cumming, GAThe pilot's improper fuel management while maneuvering resulting in a total loss of engine power due to fuel starvation.NTSB ATL05CA127Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Landrum, SCThe pilot's improper use of the flight controls (collective pitch and cylic controls) during a take off to a hover resulting in the helicopter encountering dynamic roll over and rolling over on its right side.NTSB ANC05CA099Accident · No injuriesData collectionFinal reportCessna 172 · Akiachak, AKThe pilot's delay in aborting the landing, which resulted in the airplane running off the end of the runway and nosing over. A factor associated with the accident was the rough/uneven terrain off the end of the runway.NTSB SEA05LA141Accident · No injuriesLimited investigationFinal reportCessna 206E · Stuart Island, WAThe pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…NTSB MIA05WA137Accident · No injuriesForeign investigationMooney M20C · Albenga, ItalyNTSB LAX05WA228Accident · 3 fatalForeign investigationPiper PA-31-350 · Mount Hotham, AustraliaNTSB DEN05LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Rocky Ford, COthe pilot's misjudged distance/altitude. A contributing factor was the inadvertent flap retraction.NTSB CHI05LA179Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Chicago, ILThe pushback tow driver not maintaining visual lookout for the wing walker's visual signal, and the driver not maintaining clearance from the vehicle during the pushback for taxi. Factors to the accident were the standing vehicle behind the airplane, the…NTSB ANC05CA101Accident · No injuriesData collectionFinal reportHughes 500D · Ambler, AKThe pilot's failure to maintain clearance from an object while landing, which resulted in the main rotor blades striking a tree.NTSB NYC05LA116Accident · No injuriesLimited investigationFinal reportCessna 421B · Medina, OHAn overload failure of the left main landing gear attachment assembly.NTSB MIA05CA133Accident · Minor injuriesData collectionFinal reportRobinson R44 · St. Cloud, FLThe failure of the pilot to maintain clearance with a palm tree resulting in the in-flight collision with it, and subsequent uncontrolled descent and in-flight collision with the ground.NTSB LAX05TA226Accident · Minor injuriesFinal reportAyres S2R-G10 · Wickenburg, AZthe partial loss of engine power for undetermined reasons.NTSB CHI05LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Buxton, NDA loss of engine power on takeoff due to undetermined reasons. A factor was the ditch that the airplane contacted during the forced landing.NTSB ATL05CA125Accident · No injuriesData collectionFinal reportCessna 172P · Monroeville, ALThe student pilot's failure to maintain directional control and the subsequent collision with the ground during landing.NTSB ANC05LA097Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKA fracture failure of the main landing gear leg during the landing roll, which resulted in the collapse of the main landing gear.NTSB ANC05FA098Accident · 1 fatalField investigationFinal reportMaule M-7-235 · Seward, AKThe pilot's failure to maintain minimum airspeed during final approach, which resulted in an inadvertent stall, and impact with the surface of the lake.NTSB SEA05RA139Accident · 1 fatalForeign investigationErickson Air-Crane S-64F · Rome, ItalyNTSB NYC05CA115Accident · Minor injuriesData collectionFinal reportWagner Kitfox II · Albion, NYThe pilot's loss of airplane control after inadvertently taking off while conducting high-speed taxi runs. A factor related to the accident was the pilot's lack of experience in the airplane.