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 SEA97IA219Incident · No injuriesIncident investigationFinal reportBoeing 737-3T0 · Seattle, WASeparation of the ABSB-4 aileron bus cable, resulting in reduced lateral controllability of the aircraft. Related factors were wear in the cable and inadequate inspection of the cable by company maintenance personnel.Sep 27, 1997 · N13331 · No damageNTSB NYC97LA188Accident · No injuriesLimited investigationFinal reportJackman Pitts S-1S · Hammondsport, NYthe pilot's improper flare.Sep 27, 1997 · N4241Z · Substantial damageNTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.Sep 27, 1997 · N6308W · DestroyedNTSB IAD97FA123Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Pittsfield, MAThe first pilot's improper procedures for an autorotation, and improper flare which resulted in a hard landing. Also causal was the second pilot's inadequate remedial action.Sep 27, 1997 · N5045F · DestroyedNTSB FTW97LA366Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Huntsville, TXfailure of the student pilot to maintain directional control of the helicopter during a flare to landing. Factors relating to the accident were: the student pilot's misinterpretation of the wind direction, his selection of the wrong runway, and the resultant…Sep 27, 1997 · N8316W · Substantial damageNTSB CHI97LA304Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Brooklyn, MIfailure of the pilot to see-and-avoid the transmission wires (inadequate visual lookout, and failing to maintain sufficient altitude and clearance from the obstruction).Sep 27, 1997 · N1269K · DestroyedNTSB ATL97LA142Accident · No injuriesLimited investigationFinal reportBeech 33 · Winston-Salem, NCthe pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.Sep 27, 1997 · N331DP · Substantial damageNTSB ATL97LA141Accident · No injuriesLimited investigationFinal reportTomlinson Pober Super ACE · Lebanon, TNThe pilot's failure to follow normal checklist procedures that resulted in fuel starvation.Sep 27, 1997 · N54JT · Substantial damageNTSB SEA97LA216Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Creswell, ORThe pilot's improper fuel management in which the fuel selector was positioned on tank with inadequate fuel resulting in fuel starvation. Also causal was the pilot's failure to perform the pilot operating handbook 'engine failure in flight' procedure. A…Sep 26, 1997 · N6394W · Substantial damageNTSB NYC97LA187Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 · Long Island, NYAn in-flight encounter with clear air turbulence and the passenger's failure to comply with the fasten seatbelt sign.Sep 26, 1997 · N14077 · No damageNTSB LAX97FA331Accident · 1 fatalField investigationFinal reportCessna 172K · Sandy Valley, NVthe pilot's intentional VFR flight into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from mountainous/hilly terrain. Related factors were: the high/mountainous/hilly terrain, and the adverse weather condition (low…Sep 26, 1997 · N84621 · DestroyedNTSB LAX97FA330Accident · 2 fatalField investigationFinal reportRyan Navion B · Pacoima, CAthe dual student's improper positioning of the fuel selector and the CFI's inadequate supervision, which led to a takeoff with the auxiliary fuel tank selected and resulted in fuel starvation. A contributing factor was the position of the nomenclature on the…Sep 26, 1997 · N5241K · DestroyedNTSB ATL97LA146Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay-Varina, NCThe pilot's misjudged flare, improper level-off, and improper recovery from a bounced landing.Sep 26, 1997 · N75522 · Substantial damageNTSB ANC97LA156Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Gustavus, AKThe pilot's failure to attain the proper touchdown point. Factors associated with the accident are the pilot's improper glidepath, and the rough and uneven terrain.Sep 26, 1997 · N7667H · Substantial damageNTSB ANC97FA155Accident · 1 fatalField investigationFinal reportCessna 207A · Twin Hills, AKImproper in-flight planning/decision by the pilot, and his failure to maintain sufficient altitude over mountainous terrain. Factors related to the accident were downdraft conditions, mountainous/hilly terrain, and the use of over-the-counter medications.Sep 26, 1997 · N9984M · DestroyedNTSB SEA97IA217Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Soda Springs, IDThe pilot's failure to see-and-avoid the truck. Related factors included: a truck, insufficient runway obstruction information provided in the Airport/Facility Directory by the FAA, and VASI glide path angle setting (by local airport personnel) which provided…Sep 25, 1997 · CGBUA · Minor damageNTSB FTW97LA364Accident · Serious injuriesLimited investigationFinal reportBell 206B2 · Anahuac, TXthe pilot's inability to maintain control of the helicopter after encountering a dynamic rollover due to entanglement of the external load cable with the left landing gear skid.Sep 25, 1997 · N59396 · DestroyedNTSB FTW97IA365Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-83(MD-83) · New Orleans, LARunway overrun for undetermined reasons.Sep 25, 1997 · N931TW · No damageNTSB CHI97LA301Accident · No injuriesLimited investigationFinal reportUniversal D-16 · Howell, MIthe emergency landing gear extension system being impeded by flap extension. Factors contributing to this accident are the instructor pilot's intentional feathering of the airplane's left propeller, the instructor pilot's lack of familiarity with the…Sep 25, 1997 · N110N · Substantial damageNTSB CHI97FA300Accident · 2 fatalField investigationFinal reportBeech T34B · Fremont, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall. Also causal was the pilot's ostentatious display.Sep 25, 1997 · N777SU · DestroyedNTSB ATL97LA140Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, SCthe pilot's improper use of the elevator control and delayed liftoff during takeoff, which resulted in an inadvertent porpoise, collision with the runway, and collapse of the nose gear as he aborted the takeoff.Sep 25, 1997 · N738SZ · Substantial damageNTSB SEA97FA215Accident · 3 fatalField investigationFinal reportCessna 172M · Bremerton, WAThe pilot's misjudgment of distance and altitude from the runway, and his subsequent failure to maintain clearance from the terrain. Factors contributing to the accident were dark night conditions, the pilot's improper decision to conduct the flight at night,…Sep 24, 1997 · N6756H · Substantial damageNTSB NYC97WA191Accident · 2 fatalForeign investigationBellanca 17-30A · BelgiumSep 24, 1997 · N28158 · DestroyedNTSB NYC97LA192Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest, VAthe pilot's movement of the mixture control to the idle cut-off position, during an approach to land, which resulted in a loss of engine power and a forced landing before reaching the runway.Sep 24, 1997 · N4748X · Substantial damageNTSB NYC97FA186Accident · 1 fatalField investigationFinal reportCessna 172 · Normalville, PAthe pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.Sep 24, 1997 · N35405 · DestroyedNTSB LAX97LA329Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hawthorne, NVThe pilot's inadequate compensation for the existing wind condition and his subsequent failure to maintain directional control.Sep 24, 1997 · N82259 · Substantial damageNTSB FTW97IA363Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200RS · Salt Lake City, UTThe captain's failure to maintain directional control during landing roll. Factors were the loss of hydraulic pressure in the 'A' hydraulic system, the thrust reverser failure on the number one engine, and flight crew coordination not being maintained.Sep 24, 1997 · N205AU · Minor damageNTSB CHI97LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Champaign, ILan undetermined engine and/or oil system failure that resulted in an oil leak and subsequent loss of engine power. A related factor was: high vegetation (corn crop) in the emergency landing area.Sep 24, 1997 · N1851Z · Substantial damageNTSB SEA97LA214Accident · No injuriesLimited investigationFinal reportCessna 172RG · Monroe, WAThe failure of the flight instructor to adequately perform remedial action, and her failure to abort the takeoff. Factors contributing to the accident include the premature rotation of the airplane by the dual student, the failure of the dual student to…Sep 23, 1997 · N64ML · Substantial damageNTSB NYC97FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Glastenbury, VTthe pilot's improper decision to disregard the weather briefing and continue into adverse weather which resulted in a loss of control. The weather was a factor.Sep 23, 1997 · CGHUE · DestroyedNTSB FTW97LA361Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe improper touchdown by the commercial pilot receiving instruction. A factor was the flight instructor's inadequate supervision.Sep 23, 1997 · N9264G · Substantial damageNTSB FTW97LA360Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Heber City, UTThe pilot's improper use of spoilers during the landing sequence. Factors were the embankment and the fence.Sep 23, 1997 · N7636 · Substantial damageNTSB ANC97LA154Accident · No injuriesLimited investigationFinal reportCessna 170B · Lime Village, AKThe pilot's selection of unsuitable terrain for takeoff.Sep 23, 1997 · N1831C · Substantial damageNTSB IAD97FA122Accident · 1 fatalField investigationFinal reportCessna 172P · Airville, PAThe student pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent collision with terrain.Sep 22, 1997 · N55221 · DestroyedNTSB FTW97LA356Accident · Serious injuriesLimited investigationFinal reportSikorsky S-76A · Patterson, LAfailure of the copilot to maintain a positive rate of climb after takeoff, which led to an inadvertent descent and collision with a crop of sugar cane and the ground. Factors relating to the accident were: darkness, fog, and the pilot-in-command's inadequate…Sep 22, 1997 · N517AL · Substantial damageNTSB FTW97LA355Accident · Serious injuriesLimited investigationFinal reportAmerican General AG5B · Texarkana, ARthe pilot's improper planning/decision, by failing to ensure timely refueling of the airplane, which resulted in fuel exhaustion, loss of engine power, and a forced landing.Sep 22, 1997 · N1194L · Substantial damageNTSB CHI97LA307Accident · No injuriesLimited investigationFinal reportCessna 182 · Dassel, MNthe pilot's failure to attain the proper touchdown point on the airstrip. Factors associated with the accident were the high vegetation which skewed the pilot's visual perception of threshold, and the embankment which the airplane contacted.Sep 22, 1997 · N7331Q · Substantial damageNTSB CHI97LA298Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Chicago, ILthe pilot's selection of the wrong taxi route (service road) and not maintaining clearance between his airplane's wing and a bus.Sep 22, 1997 · N4375L · Substantial damageNTSB ATL97LA136Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Zellwood, FLfailure of mechanics to adequately torque the crankcase through-bolts following a top overhaul, which subsequently resulted in a crankshaft failure. Soft/uneven terrain in the emergency landing area was a related factor.Sep 22, 1997 · N53172 · Substantial damageNTSB ATL97FA135Accident · 1 fatalField investigationFinal reportCessna 182G · Lexington, TNImproper planning/decision by the pilot, which led to the fuel exhaustion, loss of engine power, and a forced landing. Trees in the emergency landing area were a related factor.Sep 22, 1997 · N3725U · Substantial damageNTSB SEA97LA213Accident · Minor injuriesLimited investigationFinal reportBarrigar RV-6 · Goldendale, WAThe pilot's failure to maintain directional control. Factors contributing to the accident were: the pilot's delayed initiation of a go-around maneuver, downhill, and soft terrain.Sep 21, 1997 · N812AB · Substantial damageNTSB NYC97LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Easton, NYmechanical binding of the number three exhaust valve, and the pilot/owner's improper planning/decision by failing to ensure the engine was operating properly before takeoff. A related factor was: the pilot/owner's failure to ensure that annual maintenance was…Sep 21, 1997 · N6865G · Substantial damageNTSB LAX97FA328Accident · 4 fatalField investigationFinal reportBeech C23 · Torrance, CAThe failure of the pilot to attain and maintain adequate airspeed during the initial takeoff climb, which resulted in a stall/spin and subsequent collision with a building.Sep 21, 1997 · N543JL · DestroyedNTSB IAD97LA121Accident · Minor injuriesLimited investigationFinal reportPohlman/Pohlman Rotorway Exec 90 · Westminster, MDThe loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.Sep 21, 1997 · N94CJ · Substantial damageNTSB ATL97LA138Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairview, NCfuel contamination, and the pilot's inadequate preflight of the airplane. A factor relating to the accident was: an inability to attain a proper touchdown point, which led to the runway overrun.Sep 21, 1997 · N1817G · Substantial damageNTSB ATL97LA137Accident · 1 fatalLimited investigationFinal reportJohn W. Culp KR-2 · Greenwood, SCThe collision with the ground for undetermined reasons.Sep 21, 1997 · N9097E · DestroyedNTSB ANC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185E · Wasilla, AKThe loss of engine power due to water contaminated fuel, and the pilot's inadequate preflight inspection of the airplane. A factor associated with the accident was the lack of suitable terrain for a forced landing.Sep 21, 1997 · N70122 · Substantial damageNTSB FTW97LA358Accident · No injuriesLimited investigationFinal reportMooney M20C · Pettigrew, ARThe pilot's improper in-flight decision. Factors were the prevailing low ceilings, the inaccurate flight and navigation instruments as result of the failure of the engine accessories vacuum pump and the lack of suitable terrain for the pilot to execute the…Sep 20, 1997 · N7045V · Substantial damageNTSB FTW97LA357Accident · No injuriesLimited investigationFinal reportMooney M20M · Broomfield, COThe pilot's flaring of the airplane prematurely at a low airspeed that resulted in a hard landing, and an inadvertent stall during the attempted go-around and subsequent loss of control.Sep 20, 1997 · N9140Z · Substantial damageNTSB FTW97LA354Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Houma, LAThe loss of aircraft control resulting from a bird strike that severed the cyclic flight control.Sep 20, 1997 · N210PH · Substantial damage