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 NYC00LA166Accident · No injuriesLimited investigationFinal reportCessna 182 · Freedom, PAThe pilot's failure to maintain aircraft control. Factors were the soft runway, and that the pilot exceeded the aircraft's weight and balance.Jun 17, 2000 · N5746B · Substantial damageNTSB LAX00LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Coleville, CAthe tow plane pilot's inadequate airplane performance calculations.Jun 17, 2000 · N8578L · Substantial damageNTSB LAX00LA232Accident · No injuriesLimited investigationFinal reportSchleicher AS20 · Coleville, CAthe tow plane pilot's inadequate airplane performance calculations.Jun 17, 2000 · N59WM · Substantial damageNTSB DEN00LA113Accident · Minor injuriesLimited investigationFinal reportEnstrom 280CB · Ruidoso, NMthe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight planning. A contributing factor was the pilot's lack of experience in the model of helicopter.Jun 17, 2000 · N440RB · Substantial damageNTSB CHI00LA166Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNthe pilot performed inadequate remedial action to recover when the airplane ballooned during the landing flare. Factors associated with the accident were excessive airspeed during the landing and an improper landing flare.Jun 17, 2000 · N6445P · Substantial damageNTSB SEA00LA105Accident · No injuriesLimited investigationFinal reportSchmidt SEA REY · Northport, WAThe pilot's loss of directional control due to his inadequate remedial action in correcting for engine torque during the aborted landing. Factors include trees near the area where the pilot was attempting to land.Jun 16, 2000 · N304WW · Substantial damageNTSB NYC00LA164Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Louisville, KYThe pilot's improper operation of the fuel selector.Jun 16, 2000 · N485CA · Substantial damageNTSB LAX00FA230Accident · 2 fatalField investigationFinal reportMaule M4-210C · Willows, CAFailure of the pilot to maintain an adequate airspeed margin while maneuvering in steep turns at low altitude in gusty and strong tailwind conditions, which lead to a wind shear encounter and a stall/spin. A contributing factor in the accident was the pilot's…Jun 16, 2000 · N377BC · DestroyedNTSB IAD00LA052Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Mansfield, NJThe pilot's failure to comply with published emergency procedures. A factor in the accident was the pilot's inadequate preflight planning which resulted in a take-off with the inadequate amount of fuel for the flight.Jun 16, 2000 · N9014N · Substantial damageNTSB LAX00WA236Accident · No injuriesForeign investigationFairchild SA-227-AC · Gisborne, New ZealandJun 15, 2000 · ZKRCA · Substantial damageNTSB LAX00LA228Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Hayfork, CAThe failure of the pilot under instruction to maintain directional control during the landing roll and the inadequate supervision of the flight instructor, which resulted in a collision with a runway light, overload failure of the wheel axle, and the airplane…Jun 15, 2000 · N2688N · Substantial damageNTSB LAX00FA231Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · San Jose, CAThe pilot's failure to maintain control of the airplane for undetermined reasons while intentionally performing an aerobatic maneuver.Jun 15, 2000 · N8659V · DestroyedNTSB LAX00FA229Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-51 · Lihue, Kauai, HIThe first officer's delayed and misjudged landing flare resulting in a tail strike and hard landing. Contributing factors were his relative inexperience flying the type of airplane, and the captain's and the first officer's failure to adhere to required…Jun 15, 2000 · N649HA · Substantial damageNTSB DEN00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Loveland, COThe failure of the pilot to maintain directional control during takeoff roll. A factor was lack of recent experience.Jun 15, 2000 · N4948L · Substantial damageNTSB SEA00LA104Accident · 2 fatalLimited investigationFinal reportLunn RV-6A · Hammett, IDThe pilot's entering an inadvertent stall condition, and the lack of adequate altitude in which to successfully recover before ground impact.Jun 14, 2000 · N322KE · DestroyedNTSB NYC00WA161Accident · Minor injuriesForeign investigationDassault Falcon 20 · Peterborough, CanadaJun 14, 2000 · N184GA · Substantial damageNTSB LAX00LA227Accident · Minor injuriesLimited investigationFinal reportCurtis-Wright Travel AIR 4000 · Reno, NVThe pilot's improper bounced landing recovery technique and failure to maintain directional control in a quartering tailwind condition.Jun 14, 2000 · N6425 · Substantial damageNTSB LAX00LA226Accident · No injuriesLimited investigationFinal reportHughes 269C · Santa Clarita, CASettling with power precipitated by a wind direction change during the approach to land sequence and the check pilot's delayed remedial action to correct the event. Factors in the accident were crew resource management coordination concerning flight control…Jun 14, 2000 · N9692F · Substantial damageNTSB LAX00LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Lodi, CAThe pilot's inaccurate fuel consumption calculations, his misjudged in-flight planning, and his failure to flare during the landing attempt. A factor was the pilot's improper preflight inspection when he refueled the airplane.Jun 14, 2000 · N67608 · Substantial damageNTSB DEN00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dutch John, UTThe pilot's failure to compensate for wind conditions and control the aircraft while landing in gusting wind conditions.Jun 14, 2000 · N3846M · Substantial damageNTSB CHI00WA163Accident · 5 fatalForeign investigationPiper PA-31-350 · Liverpool, United KingdomJun 14, 2000 · GBMBC · DestroyedNTSB ANC00LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's inadequate compensation for wind conditions. A factor associated in the accident was a variable wind.Jun 14, 2000 · N9963Q · Substantial damageNTSB ANC00LA069Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Levelock, AKThe pilot's failure to maintain directional control during the takeoff run. A factor associated with the accident was the pilot's diverted attention while retracting the water rudders.Jun 14, 2000 · N7283 · Substantial damageNTSB LAX00LA224Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quincy, CAThe fracture and failure of the main landing gear strut to shock absorber attachment fitting.Jun 13, 2000 · N7451K · Substantial damageNTSB FTW00LA179Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Helena, ARThe pilot's failure to maintain clearance with the power lines.Jun 13, 2000 · N3096Z · DestroyedNTSB DCA00RA065Accident · No injuriesForeign investigationBoeing B737-200 · Rio De Janero, BrazilJun 13, 2000 · PPSMCNTSB CHI00GA160Accident · 2 fatalFinal reportSchweizer 269C · Topeka, KSthe pilot's failure to maintain translational lift while maneuvering, and the loss of tail rotor effectiveness. Factors relating to this accident were the tailwind, low airspeed, low rotor rpm, and the pilot's lack of overall experience in helicopters.Jun 13, 2000 · N9488F · DestroyedNTSB NYC00LA158Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Wauseon, OHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.Jun 12, 2000 · N8197W · Substantial damageNTSB LAX00LA223Accident · No injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the mechanic to refasten the cowling door prior to returning the aircraft to service.Jun 12, 2000 · N655AW · Substantial damageNTSB FTW00LA180Accident · No injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop.Jun 12, 2000 · N61441 · Substantial damageNTSB DEN00LA108Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COFailure of the instructor pilot-in-command and the pilot receiving instruction to maintain directional control. Factors were the pilot receiving instruction allowing the airplane to approach low and slow, and failure of the instructor to maintain adequate…Jun 12, 2000 · N838PC · 2 aircraft · Minor damageNTSB DCA00WA058Incident · No injuriesForeign investigationBoeing 747-200 · English Channel, United KingdomJun 12, 2000 · TFATB · Minor damageNTSB CHI00LA161Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe unlocked main landing gear and the manual gear extension not performed by the pilot. The electrical system failure was a contributing factor.Jun 12, 2000 · N7426N · Substantial damageNTSB NYC00LA163Accident · No injuriesLimited investigationFinal reportPratt Falcon XP · Montgomery, NYThe pilot's failure to maintain control of the airplane while taxiing. Factors related to the accident were the gusting wind conditions and the pilot's improper weather evaluation.Jun 11, 2000 · N544AA · Substantial damageNTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.Jun 11, 2000 · N5534V · Substantial damageNTSB MIA00IA186Incident · No injuriesIncident investigationFinal reportGrumman G-73T · Watson Island, FLthe overload separations of the control yoke on the captain's side.Jun 11, 2000 · N142PA · Minor damageNTSB IAD00LA050Accident · Serious injuriesLimited investigationFinal reportBakeng Double Deuce · West Alexandria, OHthe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's failure to properly brief/communicate transfer of the flight controls to the pilot-rated passenger.Jun 11, 2000 · N1056G · Substantial damageNTSB DEN00LA107Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Santa Fe, NMThe pilot's failure to maintain control of the aircraft. A factor was gusty wind conditions.Jun 11, 2000 · N25222 · Substantial damageNTSB DEN00LA106Accident · No injuriesLimited investigationFinal reportCessna 170B · Dutch John, UTThe pilot's failure to maintain clearance with the trees. Factors were a high-density altitude and wind gusts.Jun 11, 2000 · N4514C · DestroyedNTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…Jun 11, 2000 · N9315W · Substantial damageNTSB CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.Jun 11, 2000 · N66081 · DestroyedNTSB ANC00LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were a crosswind, and an inadvertent ground loop/swerve.Jun 11, 2000 · N8162C · Substantial damageNTSB ANC00LA067Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ninilchik, AKThe pilot's failure to maintain directional control during the take-off run. Factors associated with the accident were rough/uneven, soft terrain.Jun 11, 2000 · N95250 · Substantial damageNTSB LAX00LA220Accident · Serious injuriesLimited investigationFinal reportSikorsky HH-3F · Wellington, NVthe pilot's encounter with a wind shear while maneuvering at low altitude in mountainous terrain, which resulted in a high descent rate and inadvertent entry into a power settling condition.Jun 10, 2000 · N500XL · Substantial damageNTSB DCA00WA064Accident · 1 fatalForeign investigationBeech King Air C90B · Inshas, EgyptJun 10, 2000 · SU-UAA · DestroyedNTSB CHI00LA158Accident · No injuriesLimited investigationFinal reportTruthan Searey · Grand Rapids, MIthe pilot's failure to maintain aircraft control when the airplane encountered high winds. Factors which related to this accident were the high crosswind, the wind gusts, and the submerged object.Jun 10, 2000 · N89PJ · Substantial damageNTSB CHI00LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIaltitude/clearance from the trees not being obtained/maintained by the pilot during the initial climb after takeoff. Factors to the accident were the inadequate preflight planning/preparation by the pilot, including takeoff performance data not being…Jun 10, 2000 · N2379T · Substantial damageNTSB ATL00LA064Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Palmetto, FLThe pilot's failure to maintain airspeed during final approach to landing, resulting in an inadvertent stall.Jun 10, 2000 · N83972 · Substantial damageNTSB ATL00LA063Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Hampton, GAA total loss of engine power due to foreign object damage to the turbine wheel assembly.Jun 10, 2000 · N330CM · Substantial damageNTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…Jun 9, 2000 · N8321S · Substantial damage