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 FTW98GA097Accident · 1 fatalFinal reportBell 47G-3B-2 · Spanish Fork, UTA total loss of power due to repeated engine overspeeds. A related factor was unsuitable terrain.Jan 14, 1998 · N1461W · Substantial damageNTSB LAX98LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Goodyear, AZThe inadvertent brake activation by the student pilot while practicing touch-and-go landings.Jan 13, 1998 · N2496V · Substantial damageNTSB FTW98MA096Accident · 2 fatalMajor investigationFinal reportGates Learjet 25B · Houston, TXThe flight crew's continued descent of the airplane below the glideslope and through the published decision height without visual contact with the runway environment. Also, when the captain encountered difficulty tracking the localizer course, his improper…Jan 13, 1998 · N627WS · DestroyedNTSB MIA98LA059Accident · No injuriesLimited investigationFinal reportValentin Tiafun 17E · Pensacola, FLthe pilot's improper in-flight planning/decision and failure to see-and-avoid an obstruction during a precautionary landing on a paved road. Factors relating to the accident were: the resultant low fuel condition, and an obstruction in the precautionary…Jan 12, 1998 · N16MA · Substantial damageNTSB LAX98LA072Accident · No injuriesLimited investigationFinal reportDaniel RAF-2000 · Wahiawa, HIThe student pilot's failure to maintain directional control due to inadequate trim adjustments following installation of a larger engine.Jan 12, 1998 · N90606 · Substantial damageNTSB LAX98LA069Accident · No injuriesLimited investigationFinal reportCessna 195A · Tucson, AZThe student's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors in this accident were the inadequate supervision of the flight by the flight instructor, and the student's failure to relinquish the…Jan 12, 1998 · N1073D · Substantial damageNTSB FTW98FA093Accident · 4 fatalField investigationFinal reportBell 222UT · Sandy, UTflight by the pilot into known adverse weather conditions, and his failure (or inability) to maintain sufficient clearance or altitude from mountainous terrain. Related factors were: darkness, heavy snow, high winds, the pilot's perception of pressure that…Jan 12, 1998 · N222UH · DestroyedNTSB CHI98LA078Accident · No injuriesLimited investigationFinal reportCessna 150J · Gaylord, MIthe pilot's misjudging the flare leading to a hard landing, and the kit manufacturer's (Supplemental Type Certificate holder's) inadequate design leading to a corrosion stress fracture of the landing gear attachment. A factor was the landing gear attachment…Jan 12, 1998 · N51258 · Substantial damageNTSB MIA98LA057Accident · No injuriesLimited investigationFinal reportCessna 170 · Orlando, FLfailure of the the left brake to operate, due to a bad o-ring; and subsequent failure of the pilot to maintain directional control of the airplane during landing rollout, resulting in a ground loop and subsequent on-ground encounter with terrain.Jan 10, 1998 · N48021 · Substantial damageNTSB LAX98FA068Accident · 1 fatalField investigationFinal reportCessna 182P · Salinas, CAA loss of engine power due to a missing valve keeper. Also causal was the failure by engine maintenance personnel during engine top overhaul to install the second valve keeper in the No. 3 cylinder exhaust valve and the failure of inspection personnel to…Jan 10, 1998 · N8158M · DestroyedNTSB FTW98LA094Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Leadville, COThe failure of the pilot to maintain directional control of the airplane. Factors were a sudden windshift from a headwind to a quartering tailwind, and the snowbank.Jan 10, 1998 · N5275X · Substantial damageNTSB FTW98FA092Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Ennis, TXfailure of the flight crew to maintain minimum control speed (Vmc) during go-around from a single-engine approach, which resulted in loss of control and collision with power lines and the ground. Related factors were: a ruptured diaphragm in the distributor…Jan 10, 1998 · N556BW · DestroyedNTSB MIA98FA055Accident · 1 fatalField investigationFinal reportCessna 208B · Maiden, NCThe pilot's failure to remove the control lock prior to takeoff and his failure to abort the takeoff when he was unable to initiate a climb, resulting in the aircraft over running the runway and colliding with trees on the departure end of the runway.…Jan 9, 1998 · N913FE · Substantial damageNTSB LAX98WA073Accident · No injuriesForeign investigationPiper PA-31 · PhilippinesJan 9, 1998 · N4111M · Substantial damageNTSB FTW98LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Seguin, TXThe pilot's failure to maintain the proper descent rate.Jan 9, 1998 · N99V · Substantial damageNTSB FTW98LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyd, TXloss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall.Jan 9, 1998 · N757CH · Substantial damageNTSB FTW98FA089Accident · Serious injuriesField investigationFinal reportCameron R-420 · Yeso, NMThe rupture of the gas cell bottom (diaphragm) due to inadequate manufacturer's design and inadequate manufacturing quality control. A factor was the flight crew's performance of an emergency bailout which allowed the balloon to drift unattended for…Jan 9, 1998 · N298AR · DestroyedNTSB DCA98RA016Accident · Serious injuriesForeign investigationBoeing 767-322ER · London, United KingdomJan 9, 1998 · N653UANTSB LAX98LA070Accident · No injuriesLimited investigationFinal reportBritish Aerospace Jetstream 3101 · Phoenix, AZThe pilot's exercising poor judgement to continue to taxi under a covered T-hanger during nighttime conditions without proper clearance between the hanger and the aircraft.Jan 8, 1998 · N752JX · Substantial damageNTSB FTW98LA103Accident · No injuriesLimited investigationFinal reportCessna 340A · Bethany, OKThe pilot's flight into known adverse weather conditions which resulted in an inadvertent stall due to airframe ice. A factor was the icing conditions.Jan 8, 1998 · N26956 · Substantial damageNTSB ANC98LA015Accident · No injuriesLimited investigationFinal reportCessna 180H · Chugiak, AKthe pilot's selection of an unsuitable area for landing. A factor relating to the accident was: the crusty, snow covered surface of the airstrip.Jan 8, 1998 · N9737G · Substantial damageNTSB MIA98LA053Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pooler, GAThe pilot's failure to maintain a safe altitude and a visual lookout while operating under a special visual flight rules clearance in instrument flight rule conditions, which resulted in the helicopter colliding with trees. Contributing to the accident was…Jan 7, 1998 · N333FC · Substantial damageNTSB FTW98FA088Accident · 2 fatalField investigationFinal reportMooney M20K · Vernon, TXthe loss of control during cruise flight for undetermined reasons.Jan 7, 1998 · N231DS · DestroyedNTSB CHI98FA080Accident · 1 fatalField investigationFinal reportCessna P210N · Decatur, ILThe pilot's failure to maintain control of the airplane. Contributing factors were low ceiling and freezing drizzle.Jan 7, 1998 · N6669P · DestroyedNTSB NYC98FA060Accident · Serious injuriesField investigationFinal reportCessna 500 · West Mifflin, PAThe failure of the pilot to make a go-around when he failed to achieve a normal touchdown due to excessive speed, and which resulted in an overrun. Factors were the reduced visibility due to fog, and the wet runway.Jan 6, 1998 · N1DK · DestroyedNTSB MIA98LA054Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Orlando, FLinadvertent encounter with turbulence, which resulted spillage of hot coffee in a passenger's lap.Jan 6, 1998 · N618DL · No damageNTSB IAD98LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Philadelphia, PAfailure of the tug driver to see-and-avoid the taxiing airplane.Jan 6, 1998 · N845AA · Minor damageNTSB LAX98LA067Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Compton, CAThe failure of maintenance personnel to adequately inspect the aircraft during an annual inspection to detect a chafed and leaking engine fuel supply line.Jan 4, 1998 · N9406X · Substantial damageNTSB IAD98LA020Accident · No injuriesLimited investigationFinal reportCessna 172M · Blue Bell, PAThe pilot's failure to attain the proper touchdown point, and his failure to make a go-around, while there was sufficient runway remaining.Jan 4, 1998 · N5135R · Substantial damageNTSB FTW98LA087Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Roland, ARThe pilot's inadvertent encounter with soft, wet grass during landing.Jan 4, 1998 · N87SD · Substantial damageNTSB FTW98FA086Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tremonton, UTThe pilot's continued VFR flight into instrument meteorological conditions, becoming spatially disoriented and his subsequent loss of aircraft control. Factors were the dark night and weather conditions that included obscuration and snow.Jan 4, 1998 · N23371 · DestroyedNTSB MIA98LA051Accident · No injuriesLimited investigationFinal reportBell 47D1 · Bunnell, FLthe student pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.Jan 3, 1998 · N59326 · Substantial damageNTSB FTW98RA119Accident · 3 fatalForeign investigationLearjet 24 · Tampico, MexicoJan 3, 1998 · XARRKNTSB MIA98LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLthe pilot's inadequate compensation for wind conditions and failure to properly flare the airplane, which resulted in a hard landing and overload failure of the nose gear. The unfavorable wind conditions were related factors.Jan 2, 1998 · N757VT · Substantial damageNTSB LAX98FA066Accident · 2 fatalField investigationFinal reportCessna 172M · Chandler, AZThe pilot's intentional flying at a low altitude and failure to see and avoid the power lines during dusk conditions.Jan 2, 1998 · N20118 · DestroyedNTSB IAD98LA019Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe inadequate lookout of the pilot in command.Jan 2, 1998 · N9912L · Substantial damageNTSB FTW98LA085Accident · No injuriesLimited investigationFinal reportMooney M20J · Westport, OKThe pilot's inadequate compensation for the existing wind conditions. A factor was gusty winds.Jan 2, 1998 · N201LG · Substantial damageNTSB FTW98LA084Accident · No injuriesLimited investigationFinal reportHughes 269C · Riviera, TXThe total loss of engine power due to a fatigue failure of the crankshaft for undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jan 2, 1998 · N1091Y · Substantial damageNTSB CHI98LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Winterset, IAThe pilot misjudging his airspeed on final approach, resulting in a long touchdown and insufficient distance to stop on the remaining runway available.Jan 2, 1998 · N8350Z · Substantial damageNTSB ANC98LA014Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Mcgrath, AKThe ingestion of snow into the windshield anti-ice system, and the resulting obscured windshield which made runway alignment not possible. Factors associated with this accident were the cold windshield, the reduced performance of the windshield anti-ice…Jan 2, 1998 · N861TA · DestroyedNTSB MIA98WA048Accident · No injuriesForeign investigationBoeing 757-200 · Puerto Plata, Dominican RepublicJan 1, 1998 · G-WJA · Substantial damageNTSB NYC98LA058Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355 · New York, NYthe pilot's misjudgment of distance and speed on final approach with a tailwind, and his failure to perform a go-around in a timely manner. A factor in the accident was the strong tailwind.Dec 31, 1997 · N355DS · Substantial damageNTSB MIA98WA049Accident · 10 fatalForeign investigationBritten-Norman Islander · Rio Sidra, PanamaDec 31, 1997 · HP986 · DestroyedNTSB FTW98LA083Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Lakeview, ARthe pilot's failure to maintain runway alignment during the approach, and his delayed decision to execute a go-around. A related factor was the sunglare interfering with the pilot's view.Dec 31, 1997 · N736VQ · DestroyedNTSB CHI98LA076Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Chesterfield, MOthe pilot's failure to position the fuel selector to the proper fuel tank which led to fuel starvation.Dec 31, 1997 · N627V · Substantial damageNTSB CHI98LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boone, IAfailure of the pilot to maintain sufficient altitude/clearance from obstruction(s), while flying low over a river. The obstruction (power line) was a related factor.Dec 31, 1997 · N8465F · Substantial damageNTSB CHI98LA073Accident · 1 fatalLimited investigationFinal reportCessna 402B · Watertown, SDthe pilot's failure to perform an aircraft preflight and to remove the ice which had accumulated on the airframe. A factor involved in the accident was the icing weather conditions which existed and the ice which accumulated on the airplane.Dec 31, 1997 · N5087Q · DestroyedNTSB LAX98LA065Accident · No injuriesLimited investigationFinal reportCessna 172RG · Van Nuys, CAThe student and flight instructor's failure to verify that the landing gear was in the down position, and the design of the electrical system in which a single-point aircraft system malfunction (one open circuit breaker) disabled both the landing gear warning…Dec 30, 1997 · N5404V · Substantial damageNTSB LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.Dec 30, 1997 · N5532H · DestroyedNTSB FTW98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Grants, NMThe pilot's failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was the pilot's inadequate preflight inspection, which failed to secure the right engine oil cap, resulting in oil exhaustion and the loss of engine…Dec 30, 1997 · N87358 · Substantial damage