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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA90LA107Accident · No injuriesLimited investigationFinal reportRobert C. Campbell Quickie · Arlington, WAThe pilot did not maintain directional control of the airplane.NTSB 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.NTSB 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.NTSB NYC90DGM02Accident · 1 fatalFinal reportBell 47D1 · Meadville, PAThe pilot's failure to see and avoid the power lines.NTSB MKC90LA135Accident · No injuriesLimited investigationFinal reportCallair A-9 · Barrett, MNInadequate visual outlook and a delayed pull-up by the pilot in command.NTSB 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.NTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB ATL90FA135Accident · Serious injuriesField investigationFinal reportBoeing 727-281 · Charleston, SCImproper utilization of the emergency equipment.NTSB 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.NTSB 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.NTSB ANC90LA092Accident · No injuriesLimited investigationFinal reportCessna 185-A · Anchorage, AKFailure of the right main gear torque plate causing an uncontrollable landing roll out.NTSB SEA90TL#03Accident · No injuriesClass 3Final reportBell UH-1B · Yakima, WANTSB SEA90LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Randle, WAThe pilot failed to compensate for the wind conditions.NTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.NTSB 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.NTSB NYC90LA134Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Pittstown, NJGround resonance due to inadequate servicing and maintenance of the landing gear dampers.NTSB LAX90TL#05Accident · No injuriesClass 3Final reportBell 206L-3 · Mac Doel, CANTSB 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.NTSB 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…NTSB MIA90WA142Accident · 1 fatalForeign investigationPiper PA31T · New Town, BahamasNTSB LAX90LA225Accident · No injuriesLimited investigationFinal reportBellanca BL26 · Santa Ana, CAThe pilot's use of an improper starting technique.NTSB 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…NTSB ATL90DKJ06Accident · 1 fatalFinal reportBreezy MRU · Pell City, ALThe pilot's failure to maintain airspeed.NTSB 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…NTSB FTW90LA118Accident · No injuriesLimited investigationFinal reportBell TH13T · Paradise, LAThe failure of the pilot to properly execute the autorotation landing.NTSB 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.NTSB 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.NTSB MKC90LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Cottage Grove, MNFuel exhaustion and remedial action not performed by the pilot in command.NTSB FTW90FA119Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bossier City, LALoss of engine power for an unknown reason.NTSB 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.NTSB CHI90LA157Accident · Minor injuriesLimited investigationFinal reportBeech K-35 · Oshkosh, WIFuel mismanagement.NTSB 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.NTSB LAX90LA343Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Moorpark, CAThe pilot's failure to arrest descent for landing.NTSB LAX90LA254Accident · No injuriesLimited investigationFinal reportCessna T207A · Grand Canyon, AZThe pilot's misjudgement of clearance from a parked aircraft while taxiing.NTSB 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.NTSB 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.NTSB CHI90LA156Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Aurora, ILThe pilot's inadequate compensation for wind conditions, and his not maintaining proper directional control on landing.NTSB 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.NTSB 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.NTSB ANC90LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Chandler, AKThe pilot-in-command's failure to maintain control of the airplane.NTSB 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.NTSB 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.NTSB 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…NTSB NYC90DNE03Accident · 2 fatalFinal reportAerodyne Vector 727 Senior · Berlin, MAIn-flight failure of the wings for undetermined reason(s).