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 SEA90LA107Accident · No injuriesLimited investigationFinal reportRobert C. Campbell Quickie · Arlington, WAThe pilot did not maintain directional control of the airplane.Jun 22, 1990 · N58YC · Substantial damageNTSB SEA90LA104Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Spokane, WAThe pilot was taxiing the airplane at an excessive speed which resulted in a loss of directional control.Jun 22, 1990 · N1404V · Substantial damageNTSB NYC90LA136Accident · Minor injuriesLimited investigationFinal reportClassic Waco · Plymouth, CTThe failure of the pilot to correctly recover from a bounced landing. Factors related to the accident were: improper use of the brakes by the pilot.Jun 22, 1990 · N226HS · Substantial damageNTSB NYC90DGM02Accident · 1 fatalFinal reportBell 47D1 · Meadville, PAThe pilot's failure to see and avoid the power lines.Jun 22, 1990 · N310A · DestroyedNTSB MKC90LA135Accident · No injuriesLimited investigationFinal reportCallair A-9 · Barrett, MNInadequate visual outlook and a delayed pull-up by the pilot in command.Jun 22, 1990 · N9621Z · Substantial damageNTSB DEN90LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Hazelton, NDThe failure of the pilot in command to maintain adequate visual lookout during aerial application maneuvering.Jun 22, 1990 · N4988Y · DestroyedNTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.Jun 22, 1990 · N9926D · DestroyedNTSB CHI90LA160Accident · No injuriesLimited investigationFinal reportMooney M20J/201 · Kelleys Island, OHThe pilot's failure to maintain clearance from objects during a go-around. Factor was unfavorable wind conditions.Jun 22, 1990 · N1172G · DestroyedNTSB CHI90LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Brookville, OHThe pilot's failure to maintain positive control of the aircraft while encountering gusty, shifty winds and windshear during the initial climbout after takeoff.Jun 22, 1990 · N715HR · Substantial damageNTSB CHI90LA158Accident · No injuriesLimited investigationFinal reportCessna 310 · Moraine, OHThe pilot-in-command's failure to maintain adequate ground clearance during his approach to landing. Contributing factors were reduced visibility in fog and rain.Jun 22, 1990 · N522S · Substantial damageNTSB BFO90LA060Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Newport News, VAFuel exhaustion caused by pilot misjudging the fuel supply. Contributing to the accident was inaccurate fuel gages.Jun 22, 1990 · N8337P · Substantial damageNTSB ATL90LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Saluda, SCPilot's failure to properly plan for high density altitude operations, which resulted in settling with power to the ground.Jun 22, 1990 · N7448F · Substantial damageNTSB ATL90IA136Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAInadequate maintenance inspection of the airplane which resulted in operation of the tire while under inflated and its subsequent failure. A factor in the incident was the inadequate quality control by the tire recapping facility which failed to repair a…Jun 22, 1990 · N415EA · Minor damageNTSB ATL90FA135Accident · Serious injuriesField investigationFinal reportBoeing 727-281 · Charleston, SCImproper utilization of the emergency equipment.Jun 22, 1990 · N743US · No damageNTSB ANC90LA094Accident · No injuriesLimited investigationFinal reportCessna 170B · Port Chalmers, AKPilot-in-command's failure to properly calculate the airplane's takeoff performance and the effect of the crosswind.Jun 22, 1990 · N2556C · Substantial damageNTSB ANC90LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Big Lake, AKLoss of engine power for undetermined reasons resulting in an off airport landing in a ditch.Jun 22, 1990 · N4431Z · Substantial damageNTSB ANC90LA092Accident · No injuriesLimited investigationFinal reportCessna 185-A · Anchorage, AKFailure of the right main gear torque plate causing an uncontrollable landing roll out.Jun 22, 1990 · N4145Y · Substantial damageNTSB SEA90TL#03Accident · No injuriesClass 3Final reportBell UH-1B · Yakima, WAJun 21, 1990 · N99634 · Substantial damageNTSB SEA90LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Randle, WAThe pilot failed to compensate for the wind conditions.Jun 21, 1990 · N4428F · Substantial damageNTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.Jun 21, 1990 · N4530N · Substantial damageNTSB SEA90LA103Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekoa, WAFailure of the pilot to maintain clearance between the airplane and tall grass adjacent to the gravel strip.Jun 21, 1990 · N29SK · DestroyedNTSB NYC90LA134Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Pittstown, NJGround resonance due to inadequate servicing and maintenance of the landing gear dampers.Jun 21, 1990 · N110ES · DestroyedNTSB LAX90TL#05Accident · No injuriesClass 3Final reportBell 206L-3 · Mac Doel, CAJun 21, 1990 · N10UB · Substantial damageNTSB LAX90LA224Accident · No injuriesLimited investigationFinal reportCessna 140 · Chico, CAThe pilot improperly leveled off, failed to correct the ensuing porpoise, took improper remedial action, and improperly used the rudder and normal brakes.Jun 21, 1990 · N72122 · Substantial damageNTSB BFO90LA059Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesapeake, VAThe failure of both pilots (CFI and student pilot) to maintain adequate control of the aircraft during the landing flare and touchdown phase of flight. The student pilot's inexperience was a factor, as was the cfi's inadequate supervision during the dual…Jun 21, 1990 · N2937V · Substantial damageNTSB MIA90WA142Accident · 1 fatalForeign investigationPiper PA31T · New Town, BahamasJun 20, 1990 · N2200P · DestroyedNTSB LAX90LA225Accident · No injuriesLimited investigationFinal reportBellanca BL26 · Santa Ana, CAThe pilot's use of an improper starting technique.Jun 20, 1990 · N4034B · Substantial damageNTSB FTW90LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Fabens, TXInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…Jun 20, 1990 · N76728 · 2 aircraft · Substantial damageNTSB ATL90DKJ06Accident · 1 fatalFinal reportBreezy MRU · Pell City, ALThe pilot's failure to maintain airspeed.Jun 20, 1990 · N7ZS · Substantial damageNTSB NYC90FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, MEFailure of the pilot to maintain the proper altitude, while searching for the destination airport at night. Factors related to the accident were: darkness, fog obscuring the destination airport lights, mountainous terrain, and the lack of visual perception at…Jun 19, 1990 · N44897 · DestroyedNTSB FTW90LA118Accident · No injuriesLimited investigationFinal reportBell TH13T · Paradise, LAThe failure of the pilot to properly execute the autorotation landing.Jun 19, 1990 · N115SD · Substantial damageNTSB ATL90LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNPilot's failure to maintain directional control upon landing and subsequent premature rotation of the airplane during the go-around attempt. Contributing to the accident was the pilot's lack of total experience.Jun 19, 1990 · N9348U · Substantial damageNTSB SEA90LA102Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Troutdale, ORAn inadequate annual inspection in which maintenance personnel left an object in the area of the carburetor which resulted in an air flow blockage.Jun 18, 1990 · N8165E · Substantial damageNTSB MKC90LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Cottage Grove, MNFuel exhaustion and remedial action not performed by the pilot in command.Jun 18, 1990 · N9977E · Substantial damageNTSB FTW90FA119Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bossier City, LALoss of engine power for an unknown reason.Jun 18, 1990 · N6767W · DestroyedNTSB DEN90LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Salina, UTPower loss as a result of water contaminated fuel. Contributing to the accident were: an inadequate preflight inspection by the pilot, and rough terrain encountered during the ground run, following the forced landing.Jun 18, 1990 · N9086A · Substantial damageNTSB CHI90LA157Accident · Minor injuriesLimited investigationFinal reportBeech K-35 · Oshkosh, WIFuel mismanagement.Jun 18, 1990 · N123AT · Substantial damageNTSB NYC90LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Franklin Center, PALoss of engine power for an undetermined reason and the failure of the pilot to maintain airspeed during a forced landing which restuled in an inadvertent stall.Jun 17, 1990 · N3393A · Substantial damageNTSB LAX90LA343Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Moorpark, CAThe pilot's failure to arrest descent for landing.Jun 17, 1990 · N1523C · No damageNTSB LAX90LA254Accident · No injuriesLimited investigationFinal reportCessna T207A · Grand Canyon, AZThe pilot's misjudgement of clearance from a parked aircraft while taxiing.Jun 17, 1990 · N73204 · Substantial damageNTSB FTW90FA120Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Oklahoma City, OKFailure of the pilot to recover from the aerobatic maneuver and subsequent stall/spin, due to inadequate altitude. Fatigue may have been a related factor.Jun 17, 1990 · N26TJ · DestroyedNTSB DEN90LA138Accident · No injuriesLimited investigationFinal reportBuchanan S1-S · Albuquerque, NMThe failure of the pilot in command to adequately compensate for the wind conditions and to maintain directional control during landing roll. A contributing factor was the failure of the tailwheel locking assembly.Jun 17, 1990 · N93DB · Substantial damageNTSB CHI90LA156Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Aurora, ILThe pilot's inadequate compensation for wind conditions, and his not maintaining proper directional control on landing.Jun 17, 1990 · N59448 · Substantial damageNTSB CHI90DEK06Accident · No injuriesFinal reportCessna 175 · Zanesville, OHThe pilot's failure to properly prelfight the airplane which resulted in an inadequate fuel supply and subsequent fuel exhaustion.Jun 17, 1990 · N7296M · Substantial damageNTSB BFO90LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Alderson, WVThe pilot's failure to maintain adequate airspeed, causing the aircraft to stall. Low altitude and inattention were related factors.Jun 17, 1990 · N5964E · Substantial damageNTSB ANC90LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Chandler, AKThe pilot-in-command's failure to maintain control of the airplane.Jun 17, 1990 · N2797J · Substantial damageNTSB ANC90LA090Accident · No injuriesLimited investigationFinal reportCessna 206U · Taku, AKFailure of the pilot of N9735Z (C-206U) to see and avoid N756EJ (C-206G), and failure of company management to establish adequate separation procedures.Jun 17, 1990 · N9735Z · 2 aircraft · Minor damageNTSB NYC90LA132Accident · No injuriesLimited investigationFinal reportBoeing 747-230 · Jamaica, NYThe Boeing 747 captain misjudged clearance between his aircraft and the fokker f.28. A factor related to the accident was: self-induced pressure of the Boeing 747 captain.Jun 16, 1990 · IDEMC · 2 aircraft · Minor damageNTSB NYC90LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Augusta, MEPoor judgement of the pilot, his decision to attempt VFR flight in instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the pilot's lack of proper certification…Jun 16, 1990 · N2898U · DestroyedNTSB NYC90DNE03Accident · 2 fatalFinal reportAerodyne Vector 727 Senior · Berlin, MAIn-flight failure of the wings for undetermined reason(s).Jun 16, 1990 · UNREG · Destroyed