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 CHI00LA082Accident · 1 fatalLimited investigationFinal reportEllis Q2 · Shelbyville, INaircraft control not being maintained by the pilot during the attempted go-around. Factors to the accident were the inadequate preflight by the pilot, which resulted in fuel exhaustion. An additional factor to the accident was the inadvertent stall/mush.Feb 25, 2000 · N84DG · DestroyedNTSB ANC00LA030Accident · No injuriesLimited investigationFinal reportCessna 180H · Ophir, AKThe pilot's selection of an unsuitable taxi area. A factor associated with the accident was the soft, snow-covered terrain.Feb 25, 2000 · N8221V · Substantial damageNTSB MIA00LA094Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Clearwater, FLA total loss of engine power due to fuel starvation for und etermined reasons. This resulted in a forced landing to none suitable terrain, and a subsequent in-flight collision with trees and terrain.Feb 24, 2000 · N64WP · Substantial damageNTSB LAX00LA108Accident · No injuriesLimited investigationFinal reportBeech 35 · Desert Center, CAThe pilot's inadequate fuel management, his inaccurate fuel consumption calculations, and his improper use of the fuel selector.Feb 24, 2000 · N5127C · Substantial damageNTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…Feb 24, 2000 · N7736R · DestroyedNTSB IAD00FA023Accident · 1 fatalField investigationFinal reportAerotechnik L-13 SEH Vivat · Plymouth, MAthe flight instructor's inadequate compensation for the wind conditions. A factor was the flight instructor's improper use of speed brakes and the strong gusty winds with downdrafts.Feb 23, 2000 · N64RG · DestroyedNTSB DCA00WA028Accident · No injuriesForeign investigationBoeing B-767-300ER · Harare, ZimbabweFeb 23, 2000 · SUGAONTSB NYC00LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Center Harbor, NHThe pilot-in-command attempted a low pass and misjudged his altitude.Feb 22, 2000 · N8366N · Substantial damageNTSB NYC00RA104Accident · No injuriesForeign investigationSchweizer 269C · Prince George, CanadaFeb 21, 2000 · CGFJONTSB LAX00LA107Accident · Minor injuriesLimited investigationFinal reportHiller H-12E · Byron, CAThe pilot's inadequate visual lookout while maneuvering in proximity to wires. A contributing factor was the sun glare, which reduced the wire's conspicuity.Feb 21, 2000 · N61PC · Substantial damageNTSB LAX00LA104Accident · No injuriesLimited investigationFinal reportCohen VAN'S RV-6 · Camarillo, CAFailure of the pilot to maintain control of the aircraft during a crosswind takeoff, which resulted in a collision with the terrain and a runway light.Feb 21, 2000 · N264JC · Substantial damageNTSB LAX00IA106Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Fresno, CAMoisture contamination of the elevator trim actuator units resulting in their failure to operate at below freezing temperaturesFeb 21, 2000 · N566SW · No damageNTSB CHI00LA081Accident · No injuriesLimited investigationFinal reportCessna 172R · Waterford, MIthe directional control not obtained/maintained by the dual student and the remedial action not performed by the certified flight instructor. Contributing factors were the crosswind and the snow bank.Feb 21, 2000 · N922TA · Substantial damageNTSB CHI00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Saginaw, MIthe pilots failure to maintain directional control of the aircraft. Factors were the icy runway and the snowbank.Feb 21, 2000 · N2899D · Substantial damageNTSB CHI00LA076Accident · Serious injuriesLimited investigationFinal reportFokker F28 MK100 · Chicago, ILthe driver of the refueling truck fell asleep which resulted in him not maintaining clearance with the parked aircraft. Factors associated with the accident were severe obstructive sleep apnea and significant hypersomnolence which resulted in chronic fatigue.Feb 21, 2000 · N1403M · Substantial damageNTSB CHI00LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Wisconsin Rapid, WIThe student pilot's failure to maintain directional control. Factors were the pilot's lack of total experience and the snowbank.Feb 21, 2000 · N22017 · Substantial damageNTSB ANC00LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-T3 · Kotzebue, AKThe pilot descended below the minimum descent altitude. Factors associated with this accident were the task overload of the pilot during the instrument approach, and not performing a level off.Feb 21, 2000 · N219CS · Substantial damageNTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…Feb 20, 2000 · N811CK · Substantial damageNTSB MIA00LA095Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Delray, FLa collision with a fence while at a hover, which resulted in the helicopter rolling over.Feb 20, 2000 · N2LN · Substantial damageNTSB CHI00LA075Accident · Minor injuriesLimited investigationFinal reportKretsinger Bensen B8M · Wayzata, MNthe pilot's poor inflight planning in that he turned into a tailwind which resulted in diminished airspeed. Factors associated with the accident were the tailwind, low altitude maneuvering, the snow covered terrain, and the pilot's inability to successfully…Feb 20, 2000 · N2436 · Substantial damageNTSB CHI00LA072Accident · 1 fatalLimited investigationFinal reportCessna 180 · Tower, MNthe passenger not maintaining clearance from the rotating propeller.Feb 20, 2000 · N6545A · No damageNTSB ATL00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nashville, TNThe pilot's failure to maintain directional control during the landing roll.Feb 20, 2000 · N2233L · Substantial damageNTSB MIA00LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Miami, FLthe pilot planned the approach too low, which resulted in inadequate altitude to clear powerlines, and the subsequent in-flight collision with the ground.Feb 19, 2000 · N65819 · Substantial damageNTSB FTW00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Weir, TXThe delayed aborted takeoff by the pilot. Factors were the pilot's intentional ground loop/swerve and the tail wind.Feb 19, 2000 · N76190 · Substantial damageNTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.Feb 19, 2000 · N68197 · Substantial damageNTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…Feb 18, 2000 · N50348 · Substantial damageNTSB NYC00LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Sandusky, OHThe pilot's decision to land on a runway that was covered with ice and snow, without obtaining current wind information. Factors were the 20-knot tailwind and the snow-covered runway.Feb 18, 2000 · N87341 · Substantial damageNTSB LAX00LA109Accident · Minor injuriesLimited investigationFinal reportHughes 500C · Pohnpei (Pacific Ocean)The pilot reported that he and the observer were planning to conduct tuna spotting operations. This was to be the first flight of the day. After takeoff, about 100 to 150 feet above sea level, the helicopter began an uncommanded right turn, followed by an…Feb 18, 2000 · N437DS · DestroyedNTSB LAX00LA105Accident · Minor injuriesLimited investigationFinal reportAyres · Elko, NVthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.Feb 18, 2000 · N4011Y · Substantial damageNTSB DEN00IA052Incident · No injuriesIncident investigationFinal reportCessna TR182 · Fort Carson, COThe pilot electing to fly the aircraft with known deficiencies which resulted in a catastrophic engine failure. Factors were a connecting rod failure, and low engine oil level.Feb 17, 2000 · N155HC · No damageNTSB DCA00MA026Accident · 3 fatalClass 1 · MajorFinal reportDouglas DC-8-71F · Rancho Cordova, CAA loss of pitch control resulting from the disconnection of the right elevator control tab. The disconnection was caused by the failure to properly secure and inspect the attachment bolt.Feb 17, 2000 · N8079U · DestroyedNTSB ANC00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were soft, snow covered terrain.Feb 17, 2000 · N7164B · Substantial damageNTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.Feb 16, 2000 · N757XG · Substantial damageNTSB NYC00LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJEngine failure due to the disconnection of the intake manifold from the #3 cylinder, as a result of improper maintenance.Feb 16, 2000 · N4531F · Substantial damageNTSB MIA00LA092Accident · Serious injuriesLimited investigationFinal reportKitchens Revolution Mini 500B · Hazelhurst, MSthe pilot's failure to maintain control of the helicopter during a practice autorotation, by allowing the rotor rpm to become inadequate to cushion the touchdown, which resulted in a hard landing, and subsequent roll over.Feb 16, 2000 · N460AK · Substantial damageNTSB LAX00LA100Accident · No injuriesLimited investigationFinal reportBell 47G5 · Riverbank, CAthe pilot's failure to verify that ground personnel had disconnected the loading hose from the hopper before takeoff, resulting in restricted directional control and a hard landing.Feb 16, 2000 · N4754R · Substantial damageNTSB LAX00LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ukiah, CAfailure of the pilot to comply with the checklists in the Owner's Handbook, resulting in a total loss of engine power due to fuel exhaustion.Feb 16, 2000 · N1452T · Substantial damageNTSB LAX00GA102Accident · No injuriesFinal reportCessna T210M · Elfrida, AZThe company mechanic's failure to correctly install one or more of the crankshaft counterweight pin retaining plate snap rings, specifically ensuring that the snap rings were fully seated in their grooves. This led to the complete separation of the No. 2…Feb 16, 2000 · N761KC · Substantial damageNTSB LAX00FA101Accident · Minor injuriesField investigationFinal reportCessna 172N · Palm Springs, CAthe failure of both flight crews to see and avoid the other airplane while operating in the traffic pattern, which resulted in a mid-air collision. A contributing factor was the failure of the arriving aircraft to comply with air traffic control requests by…Feb 16, 2000 · N6479D · 2 aircraft · Substantial damageNTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.Feb 16, 2000 · N91994 · 2 aircraft · DestroyedNTSB NYC00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Parkertown, OHThe inadequate visual lookout by the pilots of both airplanes.Feb 15, 2000 · N8264G · 2 aircraft · Substantial damageNTSB FTW00LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-35K · Houston, TXThe pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.Feb 15, 2000 · N6089E · Substantial damageNTSB CHI00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Amery, WIthe pilots failure to maintain directional control. Factors to the accident were the icing conditions, the snow and ice covered runway and the snowbank.Feb 15, 2000 · N106RS · Substantial damageNTSB CHI00FA071Accident · No injuriesField investigationFinal reportBeech 1900D · Escanaba, MIthe failure of the flightcrew to maintain directional control due to unsafe/hazardous conditions on the runway that was not relayed to them. Factors were the uneven snow covered runway and the snowbank.Feb 15, 2000 · N81SK · Substantial damageNTSB ATL00FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Chamblee, GAThe S76 helicopter pilot's failure to follow ATC landing sequence clearance, which resulted in the PA-28's encounter with the helicopters wake turbulence. A factor was the air traffic controllers clearance procedure.Feb 15, 2000 · N8447Y · Substantial damageNTSB NYC00LA080Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F19 · West Lafayette, OHwas a delayed decision of the pilot to abort the landing. Factors were the wet runway, and the tail winds that prevailed in the area.Feb 14, 2000 · N3580T · Substantial damageNTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.Feb 14, 2000 · N875JC · DestroyedNTSB LAX00LA103Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)An unknown mechanical malfunction that resulted in a precautionary landing at sea and the subsequent sinking of the helicopter by an ocean swell.Feb 14, 2000 · N717ST · DestroyedNTSB LAX00LA098Accident · Serious injuriesLimited investigationFinal reportFokker FK-28-4000 · Red Bluff, CAthe failure of the passenger to fasten his seat belt without the necessity of being instructed by the flight attendant.Feb 14, 2000 · N493US · No damageNTSB LAX00FA099Accident · 2 fatalField investigationFinal reportCessna 182L · Coulterville, CAThe pilot's attempted flight into known adverse weather after receiving hazardous weather advisories, which resulted in inadvertent flight into instrument meteorological conditions while attempting to maintain VFR conditions on top. The subsequent…Feb 14, 2000 · N3324R · Destroyed