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.

NTSB CHI00LA135Accident · 1 fatalLimited investigationFinal reportRotorway Exec 162F · Ithaca, MIthe door separation for undetermined reasons and the foreign object damage due to the door impact to the tailboom and tail rotor drive system.May 13, 2000 · N962WM · DestroyedNTSB ANC00LA058Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of an unsuitable taxi area, and excessive taxi speed. A factor associated with this accident was a ditch in the taxi area.May 13, 2000 · N7944H · Substantial damageNTSB MIA00LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fernandina Bch, FLThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall., in-flight collision with terrain, and subsequent nose over.May 12, 2000 · N760WB · Substantial damageNTSB FTW00FA146Accident · 6 fatalField investigationFinal reportBeech BE-95-B55 · Houston, TXthe loss of control on takeoff as a result of the pilot's failure to remove the flight control lock due to his inadequate preflight inspection. A contributing factor was the pilot exceeding the aircraft's certificated maximum weight and balance limitations.May 12, 2000 · N4005A · DestroyedNTSB DCA00WA049Incident · No injuriesForeign investigationBoeing 747-200 · IrelandMay 12, 2000 · N520UP · No damageNTSB MIA00LA151Accident · No injuriesLimited investigationFinal reportMooney M20C · Bryson City, NCThe pilot's failure to maintain directional control on landing rollout with a known quartering crosswind, resulting in an on-ground collision with a known fixed object (wooden pallet.)May 11, 2000 · N6998U · Substantial damageNTSB MIA00LA150Accident · No injuriesLimited investigationFinal reportCessna 172H · Picayune, MSAn in-flight fire in the vicinity of the firewall from an undetermined source. This resulted in a forced landing to an airport and total consumption of the airplane by fire after landing.May 11, 2000 · N5107G · DestroyedNTSB LAX00LA195Accident · No injuriesLimited investigationFinal reportEurocopter AS350B2 · Mesa, AZthe instructor pilot's failure to maintain control of the helicopter.May 11, 2000 · N851HW · Substantial damageNTSB LAX00LA193Accident · Minor injuriesLimited investigationFinal reportSikorsky S61A · Eureka, CAthe loss of power in all engines due to the pilot's inadequate in-flight decision to continue flight with fuel level below the landing minimums specified in the flight manual, which resulted in the unporting of the fuel supply line and fuel starvation. A…May 11, 2000 · N693CC · Substantial damageNTSB LAX00FA191Accident · 6 fatalField investigationFinal reportRockwell NA-265-65 · Kaunakakai, HIInadequate crew coordination led to the captain's decision to discontinue the instrument approach procedure and initiate a maneuvering descent solely by visual references at night in an area of mountainous terrain. The crew failed to review the instrument…May 11, 2000 · N241H · DestroyedNTSB DCA00WA048Incident · No injuriesForeign investigationDouglas MD87 · NorwayMay 11, 2000 · LNRMX · Minor damageNTSB CHI00LA134Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Ham Lake, MNcarburetor ice. Factors relating to this accident were the icing conditions, the pilot's attempted emergency landing and the low altitude.May 11, 2000 · N8321K · DestroyedNTSB CHI00LA133Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Galesburg, NDthe pilot misjudged the landing flare which resulted in a hard landing.May 10, 2000 · N7185C · Substantial damageNTSB ANC00LA057Accident · No injuriesLimited investigationFinal reportCessna 180K · Anchorage, AKThe pilot's inadvertent ground loop/swerve during landing.May 10, 2000 · N2785K · Substantial damageNTSB NYC00IA131Incident · No injuriesIncident investigationFinal reportBeech BE-58 · Windsor Locks, CTInadequate screw length information provided by the manufacturer, which allowed an inadvertent installation of a holding screw that was too long, and the subsequent fracture of the switch/circuit breaker. Factors included a short circuit of the beacon motor,…May 9, 2000 · N9044V · Minor damageNTSB MIA00LA149Accident · 2 fatalLimited investigationFinal reportMorphew Pitts Model 12 · New Smyrna Bch, FLthe pilot's loss of control in flight for undetermined reasons.May 9, 2000 · N69BM · DestroyedNTSB LAX00LA192Accident · No injuriesLimited investigationFinal reportLockheed L1011-385-1 · Maui, HIThe captain's failure to maintain the proper wind-adjusted Vref airspeed, by a margin which varied from 7 to 20 knots too slow, during the final 10 seconds of the approach prior to touchdown.May 9, 2000 · N192AT · Substantial damageNTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.May 9, 2000 · N7345Z · Substantial damageNTSB LAX00LA188Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mesa, AZthe overload fracture and separation of the right main landing gear attachment.May 9, 2000 · N7648Q · Substantial damageNTSB FTW00LA145Accident · No injuriesLimited investigationFinal reportBell 47G · San Antonio, TXThe improper touchdown performed by the flight instructor.May 9, 2000 · N14408 · Substantial damageNTSB ATL00LA056Accident · Serious injuriesLimited investigationFinal reportCessna 210A · Fayetteville, NCThe pilot's improper fuel management resulting in fuel starvation. A factor was improper planned approach.May 9, 2000 · N6607X · Substantial damageNTSB ATL00LA055Accident · Minor injuriesLimited investigationFinal reportJackson Velocity RG · Kennesaw, GAA separation of the lower engine cowling and subsequent partial separation of propeller blades during a low high-speed pass. A factor was the recent maintenance work performed by the owner/pilot mechanic.May 9, 2000 · N34BD · Substantial damageNTSB ANC00FA056Accident · No injuriesField investigationFinal reportBeech B24R · Anchorage, AKA fatigue failure of the crankcase through bolt, the separation of number 3 cylinder assembly, and the inadequate maintenance/service of the airplane by company maintenance personnel.May 9, 2000 · N6951R · Substantial damageNTSB SEA00WA086Accident · No injuriesForeign investigationBell 430 · Chiu An, TaiwanMay 8, 2000 · B5553NTSB LAX00TA186Accident · No injuriesFinal reportMcDonnell Douglas 500N · Los Angeles, CAThe combined failure of the operator management and the check pilot to ensure the landing area was suitable for the slide on landing. Factors were the high vegetation that entangled the skids, resulting in the abrupt stop and nose down movement of the…May 8, 2000 · N955SD · Substantial damageNTSB FTW00RA147Accident · 3 fatalForeign investigationPiper PA-23-250F · Santa Cruz, BoliviaMay 8, 2000 · N1430NTSB FTW00FA144Accident · 2 fatalField investigationFinal reportCessna 210L · Mack, COThe pilot's continued VFR flight into instrument meteorological conditions. Factors were the mountain obscuration and the rising terrain.May 8, 2000 · N732ER · Substantial damageNTSB ANC00LA054Accident · No injuriesLimited investigationFinal reportCessna 170B · Delta Junction, AKA loss of engine power due to an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.May 8, 2000 · N992EZ · Substantial damageNTSB SEA00LA084Accident · No injuriesLimited investigationFinal reportOveross Vans RV-8 · Independence, ORThe rotation of the right fuel tank elbow fitting within the tank during previous maintenance. The improper alignment resulted in the fuel pick-up tube being mis-positioned and a subsequent starvation of fuel to the engine. Contributing factors were the…May 7, 2000 · N998TT · Substantial damageNTSB NYC00LA130Accident · Minor injuriesLimited investigationFinal reportLudeman HP-18 · Kutztown, PAThe pilot's failure to maintain control of the glider. A factor related to the accident was the pilot's lack of experience in make and model.May 7, 2000 · N67TT · DestroyedNTSB NYC00FA127Accident · Serious injuriesField investigationFinal reportEurocopter BK-117-A4 · Cincinnati, OHthe pilot's misjudgment of his closure rate, while turning to land on the rooftop helipad, which resulted in a collision with the building. Factors in the accident were the tailwind and the stuck windsock.May 7, 2000 · N911NC · Substantial damageNTSB MIA00FA146Accident · No injuriesField investigationFinal reportBeech F35 · Jackson, MSimproper rigging of the rudder/elevators and differential mechanism assembly by unknown person(s), which resulting in what the pilot describes as inflight flutter of the tail section, which resulted in damage to the aft empennage area.May 7, 2000 · N35WK · Substantial damageNTSB LAX00LA187Accident · No injuriesLimited investigationFinal reportFairchild KR-21 · Marana, AZFailure of the pilot to maintain directional control.May 7, 2000 · NC206V · Substantial damageNTSB LAX00LA184Accident · No injuriesLimited investigationFinal reportMcCoy Glasair III · Burbank, CAThe failure of the pilot to maintain a proper glidepath, which resulted in a collision with a power pole and damage to the landing gear.May 7, 2000 · N1ML · Substantial damageNTSB LAX00LA183Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Grand Canyon, AZThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during landing, resulting in the airplane veering off the runway and the subsequent collision with a culvert.May 7, 2000 · N1726X · Substantial damageNTSB FTW00TA142Accident · 1 fatalFinal reportAir Tractor AT-802A · Fort Stockton, TXThe pilot's failure to maintain clearance with the antenna tower. A factor was the smoke weather condition.May 7, 2000 · N60471 · DestroyedNTSB FTW00LA141Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monument Valley, UTThe pilot's inadequate compensation for wind conditions and his delayed go-around, which resulted in the loss of aircraft control. A factor was the turbulent weather conditions.May 7, 2000 · N3622C · Substantial damageNTSB ATL00LA054Accident · No injuriesLimited investigationFinal reportSchweizer SGU2-22E · Farmington, NCThe pilot's misjudgment of traffic pattern altitude that resulted in an off-field landing and the subsequent collision with the ground. A factor was rough terrain.May 7, 2000 · N2728Z · Substantial damageNTSB SEA00LA085Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Seaside, ORThe pilot's improper decision to continue to a point where he could not be assured of reaching a safe landing-out site if he encountered an area of significant sink after departing his planned route of flight. Factors include downdrafts, terrain that…May 6, 2000 · N34173 · Substantial damageNTSB NYC00LA129Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, PAA crack in the crankcase which resulted in a partial power loss.May 6, 2000 · N2842N · Substantial damageNTSB NYC00LA128Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Elizabethtown, KYThe pilot's loss of control due to his improper application of power and rudder, in order to arrest a swerve during the landing roll.May 6, 2000 · N67Y · Substantial damageNTSB MIA00LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Jacksonville, FLthe student pilot's misjudgment of the aircraft's altitude and subsequent maneuver to avoid an obstacle, that resulted in a loss of airspeed, an inadvertent stall, and an inflight loss of control, which resulted in damage to the aircraft during landing.May 6, 2000 · N5738S · Substantial damageNTSB MIA00LA145Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Metter, GAthe pilot's failure to maintain an adequate lookout resulting in a collision with a transmission wire that resulted in a forced landing and substantial damage to the helicopter.May 6, 2000 · N80584 · Substantial damageNTSB IAD00LA039Accident · Minor injuriesLimited investigationFinal reportRotorway Rotorway 162F Exec · Mcmurray, PAThe pilot's improper in-flight planning and decision to hover out of ground effect which resulted in a loss of tail rotor effectiveness.May 6, 2000 · N162RS · Substantial damageNTSB FTW00LA143Accident · Serious injuriesLimited investigationFinal reportLewis Spitfire/Raven · Albuquerque, NMThe pilot's inadvertent stall of the aircraft.May 6, 2000 · N17ST · Substantial damageNTSB FTW00LA140Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Bailey, COThe pilot's failure to maintain control of the helicopter while maneuvering. A factor was the high density altitude weather conditions.May 6, 2000 · N52192 · Substantial damageNTSB FTW00LA139Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Socorro, NMThe pilot's failure to maintain directional control during the aborted takeoff, which resulted in an inadvertent groundloop.May 6, 2000 · N6905M · Substantial damageNTSB FTW00LA138Accident · Minor injuriesLimited investigationFinal reportNoteman RV6-A · Kanab, UTThe partial loss of engine power as result of the failure of an exhaust valve. A factor was the lack of suitable terrain for the forced landing.May 6, 2000 · N456TP · Substantial damageNTSB CHI00LA132Accident · Minor injuriesLimited investigationFinal reportBell 206B · Eckerman, MIThe pilot's failure to attain translational lift following an aborted landing and the loss of tail rotor effectiveness encountered by the pilot. Factors to the accident were the low rotor rpm and the trees.May 6, 2000 · N9TD · DestroyedNTSB CHI00LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fulton, MOthe pilot's poor inflight planning which resulted in exceeded the proper touchdown point on the runway. A factor associated with the accident was the ditch that the airplane contacted.May 6, 2000 · N8641E · Substantial damage