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 CHI98LA120Accident · 2 fatalLimited investigationFinal reportRodgers Raven · Brandt, SDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to this accident was the pilot's lack of experience in the airplane.NTSB CHI98IA167Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD82 · Washington, DCThe failure of the Dual Axis Accelerometer.NTSB SEA98LA063Accident · 1 fatalLimited investigationFinal reportHughes 269A · Emmett, IDThe instructor pilot's failure to maintain the proper rate of descent on landing. Factors were a sudden wind shift, the instructor pilot's lack of recent experience, and terrain drop-off.NTSB NYC98FA092Accident · 1 fatalField investigationFinal reportAerostar 600A · Mapleton, MEthe failure of the pilot to maintain control of the airplane during takeoff for undetermined reasons.NTSB FTW98LA180Accident · No injuriesLimited investigationFinal reportCessna A152 · Brigham City, UTfailure of the pilot to maintain directional control of the airplane during a touch and go landing. Related factors were: the pilot allowed his attention to be diverted into the cockpit for an excessive amount of time, and the encounter with a ditch.NTSB FTW98LA179Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Carlisle, ARThe pilot's inadequate preflight and inflight planning/decision, which resulted in fuel exhaustion and the lost of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB SEA98LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Redmond, ORThe passenger-pilot's excessive rate of descent during touchdown. Factors include the pilot-in-command's inadequate recovery from a hard/bounced landing, the passenger-pilot's failure to execute a go-around after taking control of the aircraft, and gusty…NTSB SEA98IA060Incident · Minor injuriesIncident investigationFinal reportCessna 150L · Seattle, WAThe pilot's failure to reposition the flaps to the 20 degree position during a go-around, as called for in the Pilot's Operating Handbook. Factors include the pilot's decision to land long behind a departing aircraft, an encounter with wake turbulence during…NTSB MIA98LA128Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19B · Hamptonville, NCThe pilot's failure to maintain airspeed (VSO) while maneuvering at a low altitude.NTSB LAX98LA134Accident · Minor injuriesLimited investigationFinal reportBell OH-58A · Huron, CAA loss of engine power due to deteriorated O-ring seals in the fuel boost pump, which allowed air to enter the fuel lines. Factors in the accident were the inadequate manufacturer's inspection criteria for the fuel boost pump O-ring seals and the resulting…NTSB FTW98LA178Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Del Rio, TXa loss of engine power on the right engine for undetermined reasons, and the pilot's failure to maintain control of the airplane.NTSB ANC98GA036Accident · 2 fatalFinal reportCessna 185F · Nightmute, AKThe pilot's continued VFR flight into instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors in the accident were meteorological conditions consisting of low ceilings, and blowing snow,…NTSB MIA98LA127Accident · No injuriesLimited investigationFinal reportSchweizer 269-C · Ormond Beach, FLThe CFI's inadequate supervision and poor communication which led the rated student pilot to roll the throttle off, and the CFI's subsequent failure to apply forward cyclic to increase airspeed which resulted in the subsequent hard landing and roll over.NTSB LAX98LA201Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Barbara, CAThe pilot's misjudging the landing flare and subsequent hard landing.NTSB FTW98LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Las Cruces, NMthe pilot's improper use of (or failure to use) carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Related factors were: the carburetor icing (weather) conditions, and the lack of suitable terrain for a forced…NTSB MIA98LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Mallards Ldg, GAA deer on the runway which led to the pilot's evasive manuever to avoid the deer.NTSB MIA98LA122Accident · Serious injuriesLimited investigationFinal reportBrock 162F · Canton, GAthe pilot's improper use of throttle and collective pitch during initial takeoff climb, which resulted in a decay of rotor rpm and settling of the helicopter into a lake.NTSB LAX98LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Maricopa, CAThe pilot's misjudgment of the wind direction and speed, and, his inadequate compensation for those conditions. A factor in the accident was the short runway length, which limited the pilot's time to attempt a go-around.NTSB FTW98LA176Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Riverton, WYcontinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude from terrain, while manuevering to reverse direction. Related factors were: the adverse weather conditions, mountainous terrain, and…NTSB CHI98FA119Accident · 1 fatalField investigationFinal reportCessna 208B · Bismarck, NDthe pilot's failure to maintain adequate airspeed during the approach which resulted in an inadvertant stall. Factors associated with the accident were the icing conditions and the pilot's low level experience in this make and model of airplane.NTSB SEA98FA062Accident · 1 fatalField investigationFinal reportMooney M20F · Lodgepole, MTThe pilot's failure to maintain clearance from the terrain after flying into an area of known adverse weather. Factors include low ceilings, fog, snow showers, drizzle, and trees along his intended route.NTSB MIA98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Lauderdale, FLThe failure of the O-rings in the landing gear hydraulic cylinder.NTSB LAX98LA132Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Prescott, AZThe pilot's failure to attain directional control after swerving off the runway and impacting a ditch.NTSB NYC98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAloss of engine power for undetermined reason(s), which resulted in a forced landing and subsequent nose-over on uneven terrain. Uneven terrain (furrow) in the forced landing area was a related factor.NTSB NYC98FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 195 · Cape May, NJUndetermined.NTSB IAD98FA042Accident · 1 fatalField investigationFinal reportPiper PA-30 · Mcmechen, WVThe pilot's inadequate pre-flight planning and preparation which resulted in fuel exhaustion during takeoff.NTSB FTW98TA174Accident · No injuriesFinal reportBellanca 7GCBC · Mcalester, OKthe pilot's inadequate compensation for the gusty crosswinds, during recovery from a bounced landing; and his failure to maintain directional control during a go-around. Related factors were: the wind conditions, and a subsequent encounter with of a fence and…NTSB FTW98LA175Accident · No injuriesLimited investigationFinal reportNorth American Harvard 2 · Weiner, ARThe pilot's failure to maintain clearance from wires.NTSB FTW98LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Santa Teresa, NMfailure of the number 1 piston, which resulted in loss of engine power and a subsequent forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW98LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain directional control during landing. A factor was the pilot's lack of total experience in the make and model of aircraft.NTSB CHI98LA117Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Vernillion, SDthe pilot's failure (or inability) to properly compensate for wind conditions, while taxiing. Factors associated with the accident were: the sandy terrain, and the gusty tailwind condition.NTSB MIA98LA124Accident · No injuriesLimited investigationFinal reportDouglas DC-10-10F · Memphis, TNThe tug operator's (maintenance representative) inadequate visual lookout during pushback.NTSB MIA98FA121Accident · 2 fatalField investigationFinal reportRockwell GA-112TC · Allendale, SCthe pilot inadvertently entered instrument meteorological conditions, failed to maintain control of the airplane, and the airplane subsequently impacted the ground. Factors in this accident were fog, low ceilings and a dark night. An additional factor was the…NTSB FTW98LA171Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cushing, OKThe total loss of engine power resulting from a sheared accessory drive due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB DCA98WA046Incident · No injuriesForeign investigationBoeing 767-304 · Keflavik, IcelandNTSB CHI98LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INthe student pilot's failure to adequately compensate for the gusty wind conditions during landing. A factor was the gusty wind conditions.NTSB CHI98LA114Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Benton, MOan engine fire for undetermined reasons.NTSB ATL98FA060Accident · 5 fatalField investigationFinal reportCessna 525 · Marietta, GAThe failure of both pilots to see and avoid conflicting traffic, and the failure of the 172 pilot to operate the transponder as required by current regulations. Factors were the controller's failure to observe the traffic conflict, the lack of radar conflict…NTSB ANC98LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were snow covered terrain, and a hidden obstruction.NTSB NYC98LA088Accident · Serious injuriesLimited investigationFinal reportRamseyer Tierra II · Wooster, OHThe pilot's failure to maintain airspeed during the landing approach. A factor in this accident was the pilot's lack of experience in make and model.NTSB MIA98LA123Accident · No injuriesLimited investigationFinal reportCessna 402B · West Palm Beach, FLthe pilot allowed the airplane to improperly touchdown on the right main landing gear, resulting in the gear collapsing, and subsequent impact with runway visual range equipment.NTSB MIA98LA120Accident · No injuriesLimited investigationFinal reportBell 205 · Wewahitchka, FLThe pilot's loss of control as a result of erratic flight control movement due to a surge in hydraulic pressure for undetermined reasons.NTSB MIA98LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Charlotte, NCthe pilot's failure to follow proper starting procedures.NTSB FTW98FA170Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · New Orleans, LAThe pilot's inability to maintain control of the airplane after experiencing spatial disorientation. Factors were the total failure of the vacuum pump, fog, drizzle, and night conditions.NTSB CHI98LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDthe pilot failed to abort the takeoff in a timely manner and could not stop on the runway.NTSB CHI98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Sabetha, KSThe loss of engine power for undetermined reasons.NTSB ANC98LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Coldfoot, AKThe pilot's selection of unsuitable terrain for takeoff. Soft, snow covered terrain was a factor in the accident.NTSB NYC98LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Warren, PAThe pilot's failure to obtain the proper touchdown point.NTSB MIA98LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Fort Pierce, FLa loss of engine power due to fuel leakage at the fuel control, resulting in a forced landing, and subsequent impact with trees.NTSB MIA98LA115Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Contributing factors were the pilot's lack experience in this category of aircraft. An additional factor was the inadequate upgrade training provided by the company that owned the…