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 FTW98LA281Accident · Minor injuriesLimited investigationFinal reportRockwell Commander 112 · Las Vegas, NMThe pilot's improper preflight planning/preparation for a cross country flight resulting in fuel exhaustion and subsequent loss of engine power. Factors were, unsuitable terrain, lack of total aviation experience, and lack of total experience in make/model of…Jun 20, 1998 · N1188J · Substantial damageNTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.Jun 20, 1998 · N3196D · Substantial damageNTSB FTW98FA276Accident · 2 fatalField investigationFinal reportBeech A36 · Nephi, UTThe improper installation of the turbocharger exhaust stack by unknown maintenance personnel and the subsequent fire in the engine compartment due to the exhaust gas leak from the turbocharger. Factors were the total loss of engine power due to fuel line…Jun 20, 1998 · N3861K · DestroyedNTSB DCA98WA065Incident · No injuriesForeign investigationBoeing 737-3M8 · Marseilles, FranceJun 20, 1998 · FGIXP · No damageNTSB CHI98LA213Accident · No injuriesLimited investigationFinal reportCessna 310N · Janesville, WIother maintenance personnel not installing nose landing gear door linkage. Factors were the unsecured landing gear door, the nose landing gear becoming jammed and the gear extension not possible by the pilot.Jun 20, 1998 · N5030Q · Substantial damageNTSB ANC98LA082Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe rotation/slippage of the right main tire on the wheel rim, resulting in shearing of the tire tube valve stem, and subsequent tire deflation. Factors in the accident were oversize, tundra tires operated on a dry, asphalt runway surface.Jun 20, 1998 · N85CF · Substantial damageNTSB ANC98LA078Accident · No injuriesLimited investigationFinal reportCessna 207 · Holy Cross, AKThe improper installation/undertorquing of the engine crankcase bolts by company maintenance personnel, and a subsequent fracture of the engine crankshaft. A factor in the accident was unsuitable terrain for a forced landing.Jun 20, 1998 · N1673U · Substantial damageNTSB SEA98FA105Accident · 1 fatalField investigationFinal reportCessna 340 · Lincoln, MTThe pilot's improper or inadequate use of the aircraft's weather avoidance equipment, resulting in penetration of a Level 4 thunderstorm and subsequent loss of aircraft control from which the pilot did not recover. Factors included a thunderstorm and the…Jun 19, 1998 · N88JH · DestroyedNTSB MIA98LA184Accident · No injuriesLimited investigationFinal reportProgressive Aerodyne Stingray · Lake Tarpon, FLThe pilot's failure to insure that the landing gear was in the up-and-locked position prior to the water landing.Jun 19, 1998 · N6277K · Substantial damageNTSB LAX98LA229Accident · No injuriesLimited investigationFinal reportCessna 310K · Calexico, CAThe pilot's continued operation of the aircraft with known deficiencies in the landing gear indicating system. A contributing factor to the accident was the pilot's expectation that the gear would be extended and locked irrespective of the indicator lights…Jun 19, 1998 · N6994L · Substantial damageNTSB FTW98LA275Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hazen, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.Jun 19, 1998 · N3632S · Substantial damageNTSB CHI98LA254Accident · No injuriesLimited investigationFinal reportCessna 172P · Abilene, KSThe student pilot's failure to plan his approach so as to be able to stop the airplane on the runway, and the instructor pilot's delay in taking control of the airplane, so as to correct the student's mistake. A factor contributing to this accident was the…Jun 19, 1998 · N9786L · Substantial damageNTSB CHI98LA209Accident · 1 fatalLimited investigationFinal reportTillman Christen II · Howell, MIthe pilot not maintaining aircraft control during the go-around maneuver. A factor in this accident was the pilot s lack of recent experience in the accident airplane.Jun 19, 1998 · N124ET · DestroyedNTSB CHI98LA208Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Winchester, MOThe pilot's low altitude flight and failure to maintain clearance, resulting in collision with trees. A factor was trees.Jun 19, 1998 · N4539R · DestroyedNTSB SEA98FA104Accident · No injuriesField investigationFinal reportGarlick UH-1H · Couer D'Alene, IDFatigue failure of a reduction drive planetary gear. Factors include an unapproved part and plating process, and uneven terrain at the emergency landing site.Jun 18, 1998 · N869W · Substantial damageNTSB NYC98FA129Accident · 1 fatalField investigationFinal reportHawker Hunter T MK 8 · Manchester, NHFuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.Jun 18, 1998 · N745WT · DestroyedNTSB MIA98LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Holly Springs, MSThe pilot's inadequate in-flight decision with the miscalculation of the fuel consumption. Operating with an unreliable fuel gage was a contributing factor.Jun 18, 1998 · N8284W · Substantial damageNTSB LAX98LA205Accident · No injuriesLimited investigationFinal reportOfford KR-2 · San Diego, CAThe pilot's failure to attain/maintain adequate airspeed during an attempted go-around.Jun 18, 1998 · N687RL · Substantial damageNTSB FTW98LA280Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Shreveport, LAThe collapsed nose gear as a result of failure of the nose gear locking mechanism.Jun 18, 1998 · N4038B · Substantial damageNTSB FTW98LA274Accident · No injuriesLimited investigationFinal reportBell 206L4 · Hurst, TXThe flight instructor's failure to maintain control of the helicopter while attempting to increase the engine RPM while hovering. Factors were the prevailing high winds and the instructor's diverted attention.Jun 18, 1998 · N8094L · Substantial damageNTSB FTW98FA273Accident · Minor injuriesField investigationFinal reportBoeing 737-322 · Denver, COInadequate visual lookout by ground personnel (tug operator). Factors include failure of the airline to provide proper assistance (wing walkers) to the tug operator, and inadequate pushback procedures by the airline; inattention of the catering truck driver,…Jun 18, 1998 · N364UA · Substantial damageNTSB FTW98FA272Accident · 1 fatalField investigationFinal reportAyres S2R-R1340 · Humphrey, ARThe pilot's visual lookout was inadequate for undetermined reasons.Jun 18, 1998 · N4020G · DestroyedNTSB DCA98RA056Accident · 13 fatalForeign investigationSwearingen Metro II · Montreal, CanadaJun 18, 1998 · CGQALNTSB ANC98LA104Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKAn in-flight collision with a large bird.Jun 18, 1998 · N2162C · Substantial damageNTSB ANC98LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Anchorage, AKThe pilot's failure to correct engine/propeller torque and P factor, and the subsequent loss of directional control during the takeoff roll. Factors associated with the accident are the narrow, confined, takeoff area, and bordering high vegetation.Jun 18, 1998 · N3684Z · Substantial damageNTSB ANC98FA079Accident · 1 fatalField investigationFinal reportCessna 185 · Big Lake, AKThe pilot's performance of a low level maneuver. Factors were the pilot's overconfidence in his personal ability, his lack of experience in the type of airplane, and his failure to maintain adequate clearance from terrain.Jun 18, 1998 · N9982X · DestroyedNTSB SEA98LA103Accident · No injuriesLimited investigationFinal reportCasa BU-131 · Harrisburg, ORA failed bracket attaching the throttle linkage, which resulted in the inability to control power, and unsuitable terrain for a successful forced landing. Factors include soft terrain with high vegetation.Jun 17, 1998 · N1XW · Substantial damageNTSB SEA98LA102Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cascade, IDThe flight instructor's inadequate remedial action after his dual student attempted a soft field takeoff with inadequate airspeed and premature lift off.Jun 17, 1998 · N6386T · Substantial damageNTSB SEA98FA100Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Helena, MTThe pilot's failure to maintain the correct altitude while turning inbound during a procedure turn to the ILS final approach course. Factors include hilly/mountainous terrain and clouds in the area where the course reversal was performed.Jun 17, 1998 · N446JR · DestroyedNTSB LAX98TA202Accident · No injuriesFinal reportMcDonnell Douglas 600N · Laguna Beach, CAThe inadvertent entanglement of an external load, which interfered with the pilot's ability to control the aircraft.Jun 17, 1998 · N185SD · Substantial damageNTSB LAX98LA203Accident · No injuriesLimited investigationFinal reportCessna 177B · Fallon, NVThe pilot's improper use of rudder controls on a short field takeoff and his failure to maintain runway alignment.Jun 17, 1998 · N34416 · Substantial damageNTSB FTW98LA270Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Douglas, WYThe pilot's inadequate judgement in attempting to takeoff from unsuitable rough terrain.Jun 17, 1998 · N8531L · Substantial damageNTSB CHI98LA207Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Peshtigo, WIthe pilot misjudged the flare and inadvertently dragged the right sponson in the water. A factor was the pilot's lack of experience in the make and model aircraft.Jun 17, 1998 · N80026 · Substantial damageNTSB CHI98LA206Accident · Minor injuriesLimited investigationFinal reportParker Rotorway 162-F · Manchester, INthe pilot misjudged the flare.Jun 17, 1998 · N311RM · Substantial damageNTSB CHI98LA204Accident · 1 fatalLimited investigationFinal reportCessna 172R · Greenfield, INthe pilot's incapacitation due to a heart attack. A factor in the accident was the passenger's, a non-pilot, improper recovery from a bounced landing which resulted in an overload failure of the nose gear.Jun 17, 1998 · N387MA · Substantial damageNTSB CHI98LA203Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jefferson, IAthe pilot's lack of total experience in this type of aircraft and his failure to maintain directional control during an aborted takeoff. A factor was the ditch.Jun 17, 1998 · N6771F · Substantial damageNTSB SEA98LA099Accident · Minor injuriesLimited investigationFinal reportCessna T210M · La Pine, ORFuel starvation for undetermined reasons.Jun 16, 1998 · N22CT · Substantial damageNTSB LAX98LA226Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Manuel, AZThe failure of the certified flight instructor to maintain directional control while landing with a sudden windshift.Jun 16, 1998 · N519PU · Substantial damageNTSB LAX98LA200Accident · 2 fatalLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The improper shimmying of the tail rotor driveshaft by maintenance personnel which induced fatigue in the tail rotor driveshaft coupling causing it to fail, which resulted in a loss of tail rotor control. A factor is the failure of the pilot to recognize the…Jun 16, 1998 · N95MS · DestroyedNTSB LAX98FA199Accident · 2 fatalField investigationFinal reportMooney M20R · Van Nuys, CAthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions. Factors were the low ceiling, drizzle, and fog.Jun 16, 1998 · N130RB · DestroyedNTSB FTW98LA271Accident · No injuriesLimited investigationFinal reportCessna 150C · Collinsville, OKThe pilot's failure to maintain directional control during landing roll. A factor was the pilot's diverted attention.Jun 16, 1998 · N7914Z · Substantial damageNTSB CHI98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Risco, MOthe pilot's abrupt application of the brakes. Factors contributing to this accident were the pilot's inadequate preflight preparation, his delayed decision to abort the takeoff, and the soft field.Jun 16, 1998 · N36576 · Substantial damageNTSB ANC98LA076Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilots misjudgement of the tailwind, and excessive application of brakes during the off airport landing.Jun 16, 1998 · N4320Z · Substantial damageNTSB ANC98LA074Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe failure of the right main landing gear leg due to fatigue cracking. A factor associated with this accident is the inadequate inspection procedure specified by the manufacturer.Jun 16, 1998 · N185DG · Substantial damageNTSB SEA98LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Blackfoot, IDA loss of power for undetermined reasons.Jun 15, 1998 · N8553L · DestroyedNTSB LAX98LA204Accident · No injuriesLimited investigationFinal reportFife Lancair 320 · Palm Springs, CAA failure of the electrical system for undetermined reasons. The pilot's decision to continue flight with a suspected electrical system anomaly is a factor in the accident.Jun 15, 1998 · N96GF · Substantial damageNTSB FTW98LA284Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Taos, NMThe pilot's improper flare. Contributing to the accident was the sudden wind shift which rendered the aircraft uncontrollable when the aircraft was on final approach to land.Jun 15, 1998 · N94DP · Substantial damageNTSB FTW98LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Boyd, TXThe loss of engine power due to the total loss of engine oil for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jun 15, 1998 · N6217Q · Substantial damageNTSB FTW98LA263Accident · 1 fatalLimited investigationFinal reportMoore B-8MJ · Pauls Valley, OKThe non-certificated pilot's failure to maintain clearance from the hangar. A factor was the pilot's maneuvering at a low altitude.Jun 15, 1998 · N4874X · Substantial damageNTSB ATL98LA084Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Millry, ALThe fracture of the #2 cylinder connecting rod which resulted in partial loss of engine power and subsequent forced landing. A factor in the accident was the rough terrain.Jun 15, 1998 · N39853 · Substantial damage