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 CHI98LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Liberal, KSthe inadvertent stall, the pilot's inadequate preflight planning, which led to performing a takeoff with insufficient distance to clear the utility pole. A factor which contributed to this accident was the utility pole.Jun 27, 1998 · N8903W · DestroyedNTSB LAX98LA212Accident · No injuriesLimited investigationFinal reportNorth American Navion · San Andreas, CAThe pilot's improper reinstallation of the fuel selector valve handle, which led to the selection of the wrong fuel tank and fuel starvation.Jun 26, 1998 · N1400Z · Substantial damageNTSB IAD98LA075Accident · Minor injuriesLimited investigationFinal reportHoffmann Fisher FP 404 · Louisa, VALoss of engine power for undetermined reasons.Jun 26, 1998 · N6188X · Substantial damageNTSB IAD98LA073Accident · No injuriesLimited investigationFinal reportSaab-Scania F-35 Draken · Oceana, VAThe pilot-in-command's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. A related factor was the pilot's unfamiliarity with the fuel system.Jun 26, 1998 · N156XD · Substantial damageNTSB FTW98LA288Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYThe pilot's improper in-flight planning and decision making by selecting an inadequate landing area for an emergency landing when a suitable landing area was available. Factors were fuel exhaustion, inaccurate preflight planning, and lack of recent experience.Jun 26, 1998 · N4132P · Substantial damageNTSB FTW98FA283Accident · 1 fatalField investigationFinal reportMontgomery Quickie TRI-Q/200 · Fort Worth, TXThe pilot's failure to maintain aircraft control when an excessive taxispeed resulted in an inadvertent lift-off of the airplane. A factor was the pilot's lack of total experience in the make and model of aircraft.Jun 26, 1998 · N699WB · Substantial damageNTSB DCA98WA058Accident · 7 fatalForeign investigationBeech 200 · Côte d’IvoireJun 26, 1998 · ZSMSL · DestroyedNTSB CHI98LA223Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Williams, MNthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jun 26, 1998 · N5682X · Substantial damageNTSB CHI98LA222Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer 164B · Hatton, NDthe delayed abort by the pilot, the overweight condition of the airplane, and the pilot's inadequate preparation prior to takeoff. Factors contributing to this accident were the wet condition of the airstrip, the hopper dump valve not working, and the road…Jun 26, 1998 · N48532 · Substantial damageNTSB ANC98LA085Accident · No injuriesLimited investigationFinal reportLockheed L-382G · Huslia, AKThe pilot's failure to maintain proper alignment of the airplane during the landing roll.Jun 26, 1998 · N402LC · Substantial damageNTSB SEA98LA110Accident · No injuriesLimited investigationFinal reportAeronca 7-AC · Thompson Falls, MTThe instructor's inadequate remedial action with the application of excessive brake pressure.Jun 25, 1998 · N82834 · Substantial damageNTSB LAX98LA213Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Redding, CAThe pilot's excessive use of the brakes while taxiing, allowing the aircraft to nose over.Jun 25, 1998 · N30576 · Substantial damageNTSB LAX98FA211Accident · 6 fatalField investigationFinal reportEurocopter AS-350-BA · Mt. Waialeale, HIThe pilot's decision to continue VFR flight into deteriorating weather conditions consisting of lowering ceilings and visibility in mountainous terrain, which resulted in the inadvertent entry into instrument meteorological conditions and a collision with a…Jun 25, 1998 · N594BK · DestroyedNTSB CHI98LA220Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDthe pilot's failure to maintain clearance with the powerline during a swath run. A factor associated with the accident was the powerline.Jun 25, 1998 · N7174B · Substantial damageNTSB CHI98LA219Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Mobridge, SDThe pilot's failure to maintain clearance from the power lines. Factors associated with the accident were the power lines, and the separation of the vertical stabilizer and rudder which resulted in the pilot's inability to maintain directional control of the…Jun 25, 1998 · N3760E · Substantial damageNTSB CHI98LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ipswich, SDthe pilot's inadequate evaluation of the weather conditions and his failure to maintain aircraft control which resulted in a stall/mush. Factors associated with the accident were the tailwind condition and the soft terrain.Jun 25, 1998 · N31677 · Substantial damageNTSB ATL98GA086Accident · No injuriesFinal reportEctor 305A (L-19) · Morganton, NCThe inflight encounter with a downdraft which led to a stall/mush and an inflight collision with the ground. Factors were the inadequate training in mountain flying and inadequate guidelines provided by the North Carolina Forest Service.Jun 25, 1998 · N16574 · Substantial damageNTSB NYC98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Westminster, MDthe pilot's misjudgment of distance and speed during the approach/landing, and his delay in initiating a go-around. The quartering tailwind was a related factor.Jun 24, 1998 · N6640H · Substantial damageNTSB NYC98LA133Accident · No injuriesLimited investigationFinal reportCessna 170B · Oneonta, NYThe separation of the left rudder cable. A factor was chafing of the cable.Jun 24, 1998 · N3493C · DestroyedNTSB NYC98LA132Accident · Minor injuriesLimited investigationFinal reportExtra Flugzeugbau Flugzeugbau EA260 · Georgia, VTThe pilot's inadequate inflight decision and the loss of engine power due to a blocked vent line. A contributing factor was an unreliable fuel gauge.Jun 24, 1998 · N148GC · DestroyedNTSB LAX98FA210Accident · 1 fatalField investigationFinal reportCessna 152 · Santa Ana, CAThe failure of the pilot-in-command to identify a proper touchdown point on the runway and maintain an appropriate glidepath so as to remain clear of vortex turbulence from the preceding large aircraft. A factor in the accident was the pilot's failure to…Jun 24, 1998 · N67421 · DestroyedNTSB CHI98LA221Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILthe pilot's inadequate compensation for the wind conditions which resulted in a lack of directional control of the aircraft. Factors to the accident were the two airport signs and the crosswind.Jun 24, 1998 · N5255C · Substantial damageNTSB CHI98LA218Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Park Rapids, MNthe pilot's failure to maintain control of aircraft. Factors were the congested helipad conditions and wind gusts.Jun 24, 1998 · N86663 · Substantial damageNTSB MIA99FA050Accident · 2 fatalField investigationFinal reportCessna 172L · Macclenny, FLThe student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather…Jun 23, 1998 · N3853Q · DestroyedNTSB CHI98LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-375 · Stephen, MNthe visual lookout not being maintained by the pilot. A factor to the accident was the transmission wire.Jun 23, 1998 · N82585 · Substantial damageNTSB ATL98LA085Accident · No injuriesLimited investigationFinal reportStroud SKY Bolt · Mocksville, NCThe pilot's loss of directional control during landing roll when the front seat occupant inadvertently got his foot 'jammed' between the strut bungee and the rudder/brake peddle. A factor was the inadequate design of the rudder/brake peddle system.Jun 23, 1998 · N2951S · Substantial damageNTSB ANC98LA084Accident · Minor injuriesLimited investigationFinal reportBeech A-35 · Skagway, AKThe pilot's inadequate in-flight planning/decision to ensure the rudder pedals were locked in an operable position.Jun 23, 1998 · N575B · Substantial damageNTSB MIA98FA187Accident · 1 fatalField investigationFinal reportMooney M-20E · Pickens, SCA loss of engine power for undetermined reasons and the pilot not maintaining adequate clearance with objects (trees) during the emergency landing. Contributing factors were the pilot's impairment associated with the use of an antihistamine and the trees.Jun 22, 1998 · N2709W · DestroyedNTSB IAD98FA072Accident · 1 fatalField investigationFinal reportCessna 172M · Hebron, CTThe pilot's failure to obtain a weather briefing which resulted in inadvertent flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in this accident were low ceilings and…Jun 22, 1998 · N12912 · DestroyedNTSB IAD98FA070Accident · 1 fatalField investigationFinal reportCessna 172N · Ocean City, MDThe pilot's failure to maintain control of the aircraft due to spatial disorientation. Contributing factors wer fog, dark night conditions, lack of recent experience, inadequate preflight planning, and flight into known adverse weather.Jun 22, 1998 · N5944E · DestroyedNTSB DCA98WA057Incident · No injuriesForeign investigationBoeing 757-2Y0 · Larnaca, CyprusJun 22, 1998 · GOOOX · Minor damageNTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.Jun 22, 1998 · N9209R · Substantial damageNTSB CHI98LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rush City, MNthe pilot inadvertently stalled the airplane during the initial takeoff climb. Factors associated with the accident were the pilot's inattentiveness at lowering excessive flaps for takeoff.Jun 22, 1998 · N8450J · DestroyedNTSB ANC98TA083Accident · No injuriesFinal reportPiper PA-18 · Cold Bay, AKThe pilot's inadequate compensation for crosswind conditions. The presence of a crosswind was a factor in the accident.Jun 22, 1998 · N745 · Substantial damageNTSB SEA98FA109Accident · No injuriesField investigationFinal reportNolley BD-5T · Corvallis, ORThe introduction of a fuel containing an ethanol additive into fuel tanks sloshed/sealed with a compound incompatible with alcohols, resulting in debonding of the compound from the fuel tank walls, leading to partial blockage of an in-line fuel filter, and a…Jun 21, 1998 · N50TX · Substantial damageNTSB NYC98LA131Accident · No injuriesLimited investigationFinal reportNarrin-Whittman W-8 Tailwind · Germanstown, PAthe pilot's delay in initiating an abort after the wind shifted from a headwind to a tailwind during the takeoff roll. A factor was the sudden windshift.Jun 21, 1998 · N2713C · DestroyedNTSB LAX98LA209Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks DG-800B · Jean, NVThe disconnection of the elevator control attachment nut due to improper installation by the manufacturer, which resulted in the pilot's loss of control.Jun 21, 1998 · N98NL · Substantial damageNTSB IAD98LA071Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edgemere, MDThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.Jun 21, 1998 · N95415 · Substantial damageNTSB FTW98LA282Accident · No injuriesLimited investigationFinal reportBeech B19 · Frisco, TXThe student pilot's improper landing flare which resulted in a hard larding. Factors were the inadequate supervision of the flight by the flight instructor and the high winds.Jun 21, 1998 · N5110R · Substantial damageNTSB FTW98LA278Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Freer, TXThe pilot's failure to maintain tail rotor-ground clearance due to his improper flare while hovering.Jun 21, 1998 · N982SH · Substantial damageNTSB CHI98LA215Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grays Lake, ILthe pilot's not performing a recovery from a bounced landing and his not maintaining directional control. A factor was soft terrain.Jun 21, 1998 · N99548 · Substantial damageNTSB CHI98LA211Accident · Minor injuriesLimited investigationFinal reportHartzler Nieuport 11 · Gardner, KSthe pilot's inadequate weather evaluation and the aircraft stall. A factor to the accident was the gusting wind.Jun 21, 1998 · N921DH · Substantial damageNTSB CHI98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Bay City, MIa fatigue failure of the left nose gear caster bolt which resulted in a separation of the nose gear during landing.Jun 21, 1998 · N9753B · Substantial damageNTSB ANC98LA080Accident · No injuriesLimited investigationFinal reportCessna 185F · Chitina, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were uneven and soft terrain on the landing strip.Jun 21, 1998 · N80596 · Substantial damageNTSB SEA98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manzanita, ORThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a crosswind gust during the takeoff roll.Jun 20, 1998 · N6556J · Substantial damageNTSB SEA98LA107Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Murphy, IDThe pilot's decision to initiate an aborted landing at an airport where, due to the high density altitude, his aircraft was unable to outclimb the rising terrain that surrounded airport. Factors include a high density altitude and crosswinds.Jun 20, 1998 · N8030P · Substantial damageNTSB NYC98LA198Accident · No injuriesLimited investigationFinal reportCessna CE-500 · Fishers Island, NYAn intermittent short in the right wheel anti-skid system which caused a loss of braking and subsequent overrun.Jun 20, 1998 · N41SH · Substantial damageNTSB NYC98LA130Accident · No injuriesLimited investigationFinal reportCessna 172R · Milford, NYThe pilot's decision to intentionally fly below wires, which resulted in the collision with trees. A factor in the accident was the soft grass airstrip.Jun 20, 1998 · N7437A · Substantial damageNTSB LAX98LA207Accident · Serious injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Skull Valley, AZThe pilot's failure to maintain control of the aircraft while maneuvering at a low altitude.Jun 20, 1998 · N45053 · DestroyedNTSB LAX98LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Markleeville, CAThe failure of the pilot to maintain control of the aircraft on the landing roll. A factor is the pilot's neglect to lower the flaps and reduce his speed prior to landing.Jun 20, 1998 · N2772F · Substantial damage