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 ANC90LA008Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKPilot's failure to assure condition of runway prior to landing and failure to maintain runway alignment during landing.Nov 6, 1989 · N5606C · Substantial damageNTSB NYC90FA024Accident · Serious injuriesField investigationFinal reportCessna 145 · Bayport, NYThe pilot failed to maintain adequate airspeed during a go-around while recovering from a bounced landing. Contributing factor(s) was: an improper level-off and recovery from a bounced landing.Nov 5, 1989 · N19464 · Substantial damageNTSB MIA90LA026Accident · No injuriesLimited investigationFinal reportWarren/Keleher/Lark JK-1B · Homestead, FLSeizure of the left main gear wheel. Contributing factors were: the parked aircraft and vehicle (car) near the runway.Nov 5, 1989 · N131PW · Substantial damageNTSB FTW90LA023Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Thelma, TXThe pilot's failure to drain all the water from the fuel system during preflight.Nov 5, 1989 · N2566X · Substantial damageNTSB FTW90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Marietta, OKThe pilot's use of the wrong runway for takeoff. Factors related to the accident were: the tailwind and rising terrain beyond the departure end of the runway.Nov 5, 1989 · N536SF · Substantial damageNTSB FTW90FA024Accident · Serious injuriesField investigationFinal reportCameron V-77 · Tornillo, TXMechanical failure of the ignitor system, and failure of the pilot to use emergency burner relight procedures.Nov 5, 1989 · N1998Y · Substantial damageNTSB BFO90LA007Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Windmill Point, VALoss of engine power due to oil starvation.Nov 5, 1989 · N4519L · Substantial damageNTSB BFO90FA008Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Laurel, MDLost of engine power caused by material failure of the number three cylinder exhaust valve. The failure was attributed to excessive temperature.Nov 5, 1989 · N47759 · Substantial damageNTSB ATL90FA024Accident · 4 fatalField investigationFinal reportBeech C90 · Gadsden, ALFailure of the pilots of both aircraft to maintain adequate visual lookout to see-and-avoid the other aircraft.Nov 5, 1989 · N3804F · 2 aircraft · DestroyedNTSB SEA90LA011Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Chilcoot, CAThe pilot's improper inflight planning. Contributing to the accident was a down draft and the pilot's lack of recent expereince in this aircraft type.Nov 4, 1989 · N72598 · DestroyedNTSB NYC90LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Westfield, MALoss of aircraft control for an undetermined reason, which resulted in the tail rotor striking the ground and separating from the helicopter.Nov 4, 1989 · N57919 · Substantial damageNTSB LAX90LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · S. Juan Batista, CAThe pilot's intentional buzzing and failure to see and avoid a guy wire.Nov 4, 1989 · N2203V · Substantial damageNTSB LAX90DUJ05Accident · No injuriesFinal reportBell UH-1E · Mesa, AZThe inflight separation of the tail rotor due to improper maintenance procedures and the installation of incorrect attachment hardware on the tail rotor blade pitch change linkages.Nov 4, 1989 · N138US · DestroyedNTSB FTW90LA021Accident · Minor injuriesLimited investigationFinal reportCameron N-105 · Bryan, TXPilot's misjudgement/compensation for the wind change and his delayed response in initiating a climb in order to clear the tower.Nov 4, 1989 · N2055K · Substantial damageNTSB ATL90LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Dyersburg, TNPilot's temporary physical condition (possible hyperventilation or anxiety attack). Soft terrain in the emergency landing area was considered to be a related factor.Nov 4, 1989 · N95617 · Substantial damageNTSB ATL90DKG01Accident · Serious injuriesFinal reportPond Midget Mustang · Cordele, GAImproper handling of the aircraft by the pilot, which resulted in his loss of control. His lack of experience in this type of aircraft was a related factor.Nov 4, 1989 · N9WT · DestroyedNTSB MIA90WA025Accident · No injuriesForeign investigationPiper PA-31 · Stella Maris, BahamasNov 3, 1989 · N82DN · Substantial damageNTSB MIA90LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Immokalee, FLFailure of the pilot to maintain proper altitude and his failure to maintain adequate visual lookout to see and avoid obstructions. The static line (obstruction) was a contributing factor.Nov 3, 1989 · N4129E · Substantial damageNTSB ATL90GA023Accident · 1 fatalFinal reportSikorsky SK-70 · Marathon, FLFailure of the pilot to maintain the proper altitude over the ocean water. Factors related to the accident were: continued operation of the helicopter with a known partial deficiency of the radio altimeter/warning system, darkness, the pilot's lack of visual…Nov 3, 1989 · N23576 · DestroyedNTSB MKC90LA021Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Saint Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Darkness was a related factor.Nov 2, 1989 · N3174S · Substantial damageNTSB MIA90LA023Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Loxahatchee, FLFailure of the pilot to maintain rotor RPM after pulling up from a swath run. A related factor was the presence of trees.Nov 2, 1989 · N93067 · Substantial damageNTSB MIA90FA021Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Apopka, FLFailure of the pilot to maintain altitude/clearance above the water, while proceeding over a lake and approaching the vicinity of the airport.Nov 2, 1989 · N7526S · DestroyedNTSB ATL90FA022Accident · 1 fatalField investigationFinal reportCessna 182P · Darlington, SCThe pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.Nov 2, 1989 · N58735 · DestroyedNTSB MIA90FA022Accident · 1 fatalField investigationFinal reportPiper 601P · Fort Myers, FLFailure of the pilot to properly follow the IFR procedure and to identify the decision height. Factors related to the accident were: the adverse weather conditions, darkness, the pilot's lack of visual perception without the approach lights, and tree(s) in…Nov 1, 1989 · N50TR · DestroyedNTSB LAX90DVM01Accident · No injuriesFinal reportBell 47G-5 · Guadalupe, CAThe pilot's failure to maintain sufficient clearance allowing the aircraft to collide with a wooden power pole. Contributing to the accident was the sunglare which inhibited the pilot's vision.Nov 1, 1989 · N4798R · Substantial damageNTSB DEN90FA017Accident · 1 fatalField investigationFinal reportCessna 172RG · Laramie, WYThe loss of control of the airplane in instrument meteorological conditions after the pilot became spatially disoriented. Contributing to the accident was the failure of the vacuum system which rendered the vacuum/gyro instruments inoperative. Also…Nov 1, 1989 · N4825V · DestroyedNTSB MIA90IA020Incident · No injuriesIncident investigationFinal reportClassic YMF-5 · Marathon, FLThe pilot's incorrect elevator control while taxiing with a quartering tailwind. Contributing to the incident was the tailwind condition.Oct 31, 1989 · N89B · Minor damageNTSB LAX90LA012Accident · No injuriesLimited investigationFinal reportCulver VEE · Santa Paula, CAThe pilot's failure to maintain sufficient airspeed for a positive rate of climb.Oct 31, 1989 · N3036K · Substantial damageNTSB LAX90FA019Accident · 1 fatalField investigationFinal reportBeech 77 · Kalihi, HIVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.Oct 31, 1989 · N3731X · DestroyedNTSB CHI90DEG01Accident · 2 fatalFinal reportMccomb RV-4 · Eaton, OHPoor in-flight planning/decision by the pilot which resulted in spatial disorientation and an inadvertent spiral. Factors related to the accident were: the dark night and instrument lights not installed.Oct 31, 1989 · N828BM · DestroyedNTSB SEA90LA026Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Newberg, ORFailure of the pilot to maintain runway alignment. The birds & debris (hidding obstructions) were related factors.Oct 30, 1989 · N4133B · Substantial damageNTSB NYC90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Lowell, MAThe failure of the pilot to assure that the float wheels were retracted prior to a water landing. A contributing factor was the extension of the left float wheels for an undetermined reason.Oct 29, 1989 · N2537G · Substantial damageNTSB NYC90LA019Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Windham, CTThe pilot's failure to achieve proper lift-off speed.Oct 29, 1989 · N1160K · Substantial damageNTSB MKC90FA020Accident · 1 fatalField investigationFinal reportCessna 402B · Little Rock, ARA leak in the aircraft's fuel system which resulted in an in-flight fire. The origin of the fuel leak was not determined.Oct 29, 1989 · N6382X · Substantial damageNTSB LAX90LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palo Alto, CAThe flight instructor improperly supervised the flight and the dual student pilot failed to properly set the fuel selector valve in the proper position. Both pilots failed to use the emergency checklist.Oct 29, 1989 · N9292Z · Substantial damageNTSB LAX90LA018Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAThe failure of the pilot to maintain directional control during the landing roll.Oct 29, 1989 · N53893 · Substantial damageNTSB LAX90LA015Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Borrego Springs, CAThe failure of the engine exhaust valve.Oct 29, 1989 · N9330L · Substantial damageNTSB FTW90LA019Accident · No injuriesLimited investigationFinal reportCessna 182J · Leesville, LAThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was: the lack of a suitable landing area.Oct 29, 1989 · N2792F · Substantial damageNTSB DCA90MA005Accident · 20 fatalClass 1 · MajorFinal reportDe Havilland DHC-6-300 · Halawa,Molokai, HIThe airplane's controlled flight into terrain as a result of the decision of the captain to continue flight under visual flight rules at night into instrument meteorological conditions (IMC), which obscured rising mountainous terrain. Contributing to the…Oct 29, 1989 · N707PV · DestroyedNTSB CHI90LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe pilot's inadvertent selection of unsuitable terrain (taxiway/construction area). The steel marker poles contributed to the aircraft damage.Oct 29, 1989 · N1316U · Substantial damageNTSB CHI90LA020Accident · No injuriesLimited investigationFinal reportBell 47G-2A-1 · Plymouth, INThe student's improper use of the cyclic control and the instructor's (cfi's) inadequate supervision.Oct 29, 1989 · N500CD · Substantial damageNTSB BFO90LA005Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Churchville, MDThe pilot not maintaining adequate clearance from the wind sock during an aborted landing. A contributing factor was the presence of another aircraft.Oct 29, 1989 · N7871S · Substantial damageNTSB BFO90LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Wytheville, VAThe loss of propeller control which resulted in engine shutdown and subsequent forced landing on unsuitable terrain.Oct 29, 1989 · N2224P · Substantial damageNTSB BFO90FA003Accident · 2 fatalField investigationFinal reportCessna 177 · Mchenry, MDThe pilot's failure to obtain adequate takeoff airspeed as a result of an improper flap setting. Contributing factors were a takeoff with a tailwind, an upsloping runway, and high density altitude.Oct 29, 1989 · N30036 · DestroyedNTSB ATL90LA018Accident · No injuriesLimited investigationFinal reportBeech A23A · Roopville, GAThe pilot's disregard for a tailwind during landing, his delay in executing a go around when he noted excessive speed during the landing roll, and improper go around procedures.Oct 29, 1989 · N6929Q · Substantial damageNTSB ATL90FA017Accident · 1 fatalField investigationFinal reportCessna 150M · Carrollton, OHThe pilot failed to maintain adequate airspeed while maneuvering, which led to an inadvertent stall/spin. Contributing to the accident were the pilot's apparent desire to show off, and the low altitude at which he chose to perform the maneuver.Oct 29, 1989 · N66538 · DestroyedNTSB NYC90LA023Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Friendsville, PAThe pilot failed to maintain airspeed and stalled the aircraft.Oct 28, 1989 · N4428E · DestroyedNTSB NYC90LA022Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Pittstown, NJThe pilot's failure to maintain directional control during landing.Oct 28, 1989 · N771VY · Substantial damageNTSB NYC90LA021Accident · Minor injuriesLimited investigationFinal reportBoeing B75N · Willimantic, MEAn inadvertent stall clearing trees during a forced landing following a power loss due to a fuel line separating from the carburetor and fuel starvation.Oct 28, 1989 · N68972 · Substantial damageNTSB NYC90LA018Accident · No injuriesLimited investigationFinal reportMaule M-5 · Plattsburgh, NYThe pilot's inadequate preflight planning to assure clearance from the surrounding brush.Oct 28, 1989 · N6224M · Substantial damage