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 CHI98LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkhart, INthe pilot's disorientation that led him to believe he was on the active runway. A factor was the pilot's inattentiveness.May 7, 1998 · N8994V · Substantial damageNTSB CHI98LA142Accident · 1 fatalLimited investigationFinal reportBombardier Rans S-9 · Waukee, IAthe pilot's failure to maintain control of the airplane which resulted in a stall while performing intentional buzzing maneuvers.May 7, 1998 · N5360D · Substantial damageNTSB ANC98LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions. A factor was the gusting crosswind.May 7, 1998 · N7468D · Substantial damageNTSB MIA98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Woodstock, GAThe pilot's failure to establish a positive climb to outclimb obstacle (tree) and his decision to execute a takeoff with a tailwind.May 6, 1998 · N3900P · Substantial damageNTSB IAD98LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe pilot's failure to maintain adequate airspeed during an aborted landing which resulted in an inadvertent stall/spin.May 6, 1998 · N21971 · Substantial damageNTSB IAD98LA051Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Chesterfield, VAThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power.May 6, 1998 · N4543K · DestroyedNTSB FTW98FA203Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Olustee, OKThe student pilot's improper decision to attempt an 180 degree turn to return to the takeoff runway.May 6, 1998 · N87125 · Substantial damageNTSB DCA98WA041Accident · 87 fatalForeign investigationBoeing 737-200 · Andoas, PeruMay 6, 1998 · UNK · DestroyedNTSB SEA98LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from terrain. Clouds and mountainous terrain were a factor.May 5, 1998 · N6468D · Substantial damageNTSB MIA98WA151Accident · No injuriesForeign investigationBoeing 737-200 · Havana, CubaMay 5, 1998 · N261LR · Substantial damageNTSB LAX98FA154Accident · 1 fatalField investigationFinal reportMooney M20K · Bakersfield, CAThe pilot's operation of the airplane at a speed well in excess of it's designed never exceed speed that resulted in elevator flutter and in-flight failure of the airplane. Turbulence and icing conditions were factors in the accident.May 5, 1998 · N231BY · DestroyedNTSB LAX98FA153Accident · 1 fatalField investigationFinal reportBeech G33 · Crestline, CAthe pilot's intentional flight into known instrument weather conditions while operating VFR.May 5, 1998 · N9471Q · DestroyedNTSB DCA98WA054Accident · Minor injuriesForeign investigationBell Huey II · Ease Of Lima, PeruMay 5, 1998 · UNK · Substantial damageNTSB CHI98LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Omaha, NEThe fatigue failure of the crankshaft which resulted from a spun bearing and the low altitude at which the loss of engine power occurred. A factor in the accident was the embankment on which the airplane was landed.May 5, 1998 · N24435 · Substantial damageNTSB ANC98LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Talkeetna, AKthe pilot's inadequate aircraft preflight. A factor was the inadvertent activation of the parking brake.May 5, 1998 · N4319Z · Substantial damageNTSB NYC98IA106Incident · No injuriesIncident investigationFinal reportBeech 1900D · Syracuse, NYImproper maintenance which resulted in a cross threaded\ mistapped counterweight bolt hole, and the subsequent failure of the propeller counterweight clamp assembly. Also causal was the inadequate inspection of the counterweight clamp threads by maintenance…May 4, 1998 · N832CA · Minor damageNTSB FTW98LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lewisville, ARThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 4, 1998 · N48484 · Substantial damageNTSB SEA98LA071Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocean Shores, WAThe pilot's failure to maintain clearance from a light standard (utility pole) just off the edge of the parking ramp. Factors include a light standard placed near the edge of the parking ramp.May 3, 1998 · N1673V · Substantial damageNTSB SEA98LA069Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Stanwood, WAThe failure of the number two connecting rod, which led to additional internal engine damage and a complete loss of power. Factors include soft terrain in the area where the pilot found it necessary to execute his forced landing.May 3, 1998 · N7965J · Substantial damageNTSB CHI98LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · East Hannibal, ILthe pilot's inadequate preflight planning/preparation, and his improper in-flight planning/decision. A factor was fuel exhaustion.May 3, 1998 · N75306 · Substantial damageNTSB CHI98LA138Accident · No injuriesLimited investigationFinal reportCessna 150H · Benton, KSthe pilot's failure to assure an adequate fuel supply to complete the flight by refueling the airplane en route resulting in fuel exhaustion. A factor was the hedgerow which was contacted during the landing and the dark night conditions.May 3, 1998 · N6977S · Substantial damageNTSB ATL98LA073Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger II · Savannah, GAIn flight collision with terrain for undetermined reasons. A contributing factor was the pilot's lack of familiarity with the aircraft.May 3, 1998 · UNREG · DestroyedNTSB ATL98LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Key West, FLfailure of the student pilot to maintain directional control of the airplane during the landing roll. The student pilot's lack of experience in the make and model of airplane was a related factor.May 3, 1998 · N54743 · Substantial damageNTSB ATL98LA071Accident · Serious injuriesLimited investigationFinal reportBellanca 7-GCBC · Sebring, FLThe pilot's improper handling of the airplane which led to an inadvertent stall. A factor was the loss of engine power for undetermined reasons.May 3, 1998 · N4ME · DestroyedNTSB LAX98LA151Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Auburn, CAThe pilot's improper use of carburetor heat and the rough/uneven (furrowed) terrain. A contributing factor was carburetor icing conditions.May 2, 1998 · N2435K · Substantial damageNTSB FTW98LA209Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Usaf Academy, COThe pilot exceeding the airplane's crosswind component, and his failure to maintain directional control. Factors were the crosswind and gusts.May 2, 1998 · N5043N · Substantial damageNTSB SEA98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Monroe, WAFuel starvation due to the flight instructor's improper in-flight decision to simulate an engine failure by pulling the mixture control toward the lean position until the engine shut down, and his failure to return the mixture to the rich position until after…May 1, 1998 · N5157W · Substantial damageNTSB LAX98FA149Accident · 1 fatalField investigationFinal reportRobinson R22 · Irwindale, CAThe failure of the pilot to observe in a timely manner and maintain clearance from electrical power transmission wires and her improper maneuver to avoid the obstruction.May 1, 1998 · N8365D · DestroyedNTSB FTW98LA207Accident · No injuriesLimited investigationFinal reportSchrack Starduster TOO · Hilltop Lakes, TXThe pilot's failure to obtain/maintain the proper descent rate which resulted in a hard landing.May 1, 1998 · N5462 · Substantial damageNTSB FTW98LA202Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Levelland, TXthe pilot's inaccurate weather evaluation, subsequent encounter with a severe downdraft, and failure (or inability) to compensate for the wind (downdraft) condition. The high density altitude was a related factor.May 1, 1998 · N459U · DestroyedNTSB FTW98LA201Accident · No injuriesLimited investigationFinal reportCessna 320D · Greybull, WYStress overload failure of the bellcrank assembly of the left landing gear.May 1, 1998 · N3316Q · Substantial damageNTSB FTW98LA200Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Jackson, WYthe pilot's misjudgment of distance and speed, while approaching to land; his failure to attain a proper touchdown point for landing; and his failure to go around, while there was sufficient runway remaining. A related factor was the uneven terrain, which was…May 1, 1998 · N8536P · Substantial damageNTSB DCA98WA040Incident · No injuriesForeign investigationDouglas MD-80 · Wuhan, ChinaMay 1, 1998 · CJ635 · No damageNTSB ATL98LA070Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Brewton, ALImproper maintenance procedures used to overhaul the engine, which led to the crankshaft failure. Contributing to the severity of the accident was the fence.May 1, 1998 · N6645V · Substantial damageNTSB ATL98LA069Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Panama City, FLThe engine crankshaft fracturing, leading to total powerplant failure. Contributing to the severity of the accident was a utility pole.May 1, 1998 · N4121W · Substantial damageNTSB FTW98LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COthe student pilot's improper use of the rudder controls, which resulted in loss of directional control, a ground swerve, an encounter with soft terrain, and a nose over. The soft terrain was a related factor.Apr 30, 1998 · N25525 · Substantial damageNTSB FTW98IA196Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-51 · Brownsville, TXThe flightcrew experienced physical impairment resulting from an accumulation in the cockpit of carbon dioxide fumes produced by dry ice, a hazardous material, carried in the main cargo compartment.Apr 30, 1998 · N507DC · No damageNTSB CHI98IA169Incident · No injuriesIncident investigationFinal reportDouglas DC-9-34 · St. Louis, MOthe yaw rate gyro of the Stab Aug Computer had been installed in a reverse position that was 180 degrees opposite from the correct position.Apr 30, 1998 · N928L · No damageNTSB NYC98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAfailure of the pilot to maintain directional control of the airplane during the takeoff roll; and/or his failure to abort the takeoff, while there was sufficient space available to do so without hitting trees.Apr 29, 1998 · N4506Z · DestroyedNTSB NYC98LA104Accident · 2 fatalLimited investigationFinal reportHispano Aviacion HA200B Saeta · Xenia, OHThe pilot's failure to maintain altitude clearance with trees after an improper decision to perform low level aerobatics.Apr 29, 1998 · N9108Q · DestroyedNTSB IAD98LA050Accident · Minor injuriesLimited investigationFinal reportMcClead Varieze · Middlebury, CTthe pilot's inadequate preflight when he did not secure the right wing fuel tank cap which led to fuel exhaustion.Apr 29, 1998 · N728RJ · DestroyedNTSB FTW98LA226Accident · No injuriesLimited investigationFinal reportCessna 210A · Weatherford, TXThe restricted movement of the elevator control system by a bolt.Apr 29, 1998 · N9466X · Substantial damageNTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.Apr 29, 1998 · N201FM · Substantial damageNTSB LAX98LA147Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Maricopa, AZThe pilot's loss of control in flight for undetermined reasons.Apr 28, 1998 · N34187 · Substantial damageNTSB LAX98LA146Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Sacramento, CAthe CFI's failure to follow procedures and directives, and the use of an improper technique to transition from an autorotative descent to a hover, which exceeded the aircraft's performance capabilities and resulted in a unplanned hard landing. The soft…Apr 28, 1998 · N805EH · Substantial damageNTSB ATL98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Tampa, FLIn-flight collision with a bird, which separated a fuel line causing a loss of engine power, and resulting in an emergency landing on unsuitable terrain.Apr 28, 1998 · N2125N · Substantial damageNTSB ANC98FA043Accident · 1 fatalField investigationFinal reportTaylorcraft BL12 · Sitka, AKThe pilot's attempted VFR flight into instrument meteorological conditions. Contributing factors were clouds, the pilot's lack of instrument flight experience, obscuration and mountainous terrain.Apr 28, 1998 · N33902 · DestroyedNTSB LAX98LA144Accident · Minor injuriesLimited investigationFinal reportSchweizer G164D · Robbins, CAAircraft rudder post failure due to extensive rusting which resulted in a partial loss of aircraft control.Apr 27, 1998 · N31785 · DestroyedNTSB DCA98WA042Incident · No injuriesForeign investigationBoeing 737-500 · Bremen, GermanyApr 27, 1998 · DAHLN · No damageNTSB CHI98IA136Incident · No injuriesIncident investigationFinal reportRobinson R22 Beta · Franklin, WIThe mechanic's failure to follow the manufacturer's maintenance rebuilding instructions.Apr 27, 1998 · N8331F · Minor damage