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 FTW89LA122Accident · No injuriesLimited investigationFinal reportCessna 206 · Del Rio, TXPilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise.Jul 1, 1989 · N579LD · Substantial damageNTSB DEN89LA150Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Telluride, COInadequate compensation for wind conditions by the pilot and his failure to maintain runway alignment. Contributing factors were wind conditions, high density altitude, and trees.Jul 1, 1989 · N7385Y · DestroyedNTSB BFO89LA054Accident · No injuriesLimited investigationFinal reportHughes 269C · Baltimore, MDThe pilot landed on unsuitable soft terrain which caused the landing skid to sink into the ground. This resulted in a landing skid overload failure and nose over of the helicopter. Contributing to the accident was the soft terrain.Jul 1, 1989 · N1113Z · Substantial damageNTSB BFO89LA053Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Ocean City, MDLoss of engine power from exhaust gas leakage into the carburetor inlet, causing engine air starvation, and material failure of the exhaust manifold. .Jul 1, 1989 · N7521F · Substantial damageNTSB BFO89LA052Accident · Minor injuriesLimited investigationFinal reportMooney M-20F · Mchenry, MDThe pilot landed hard and collapsed the landing gear when he failed to arrest his descent rate during landing. Afterwardas he tried to make a go-around the pilot did not obtain adequate flying speed, the aircraft stalled and collided with the ground.Jul 1, 1989 · N7784M · Substantial damageNTSB BFO89LA051Accident · No injuriesLimited investigationFinal reportCessna 140 · Bridgeport, WVThe loss of engine power because of fuel starvation. Fuel starvation occurred because of unporting of fuel from the tank outlet when the aircraft was in a slip attitude shortly before the power loss. A contributing factor is inadequate information in the…Jul 1, 1989 · N1975N · Substantial damageNTSB ATL89FA173Accident · 4 fatalField investigationFinal reportCessna 210H · Piney Flats, TNThe pilot's failure to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft while attempting to recover from an uncontrolled descent. Factors related to the accident were: darkness,…Jul 1, 1989 · N5939F · DestroyedNTSB ANC89LA113Accident · No injuriesLimited investigationFinal reportCessna 150 · Duffys Tavern, AKThe selection of the soft sandy strip for takeoff by the pilot and his premature liftoff combined to make it impossible to attain climb airspeed before colliding with bushes at the end of the runway.Jul 1, 1989 · N3200X · Substantial damageNTSB ANC89LA112Accident · No injuriesLimited investigationFinal reportCessna 185F · Dillingham, AKImproper planning/decision by the pilot & a strong downdraft.Jul 1, 1989 · N6305E · Substantial damageNTSB ANC89LA111Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. The crosswind and gusts were contributing factors.Jul 1, 1989 · N75LE · Substantial damageNTSB SEA89LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Snoqualmie Pass, WAImproper in-flight planning/descision by the pilot, which resulted in the aircraft entering a box canyon with insufficient speed and altitude to maneuver out of the confined area. Factors related to the accident were: the pilot's continued flight into known…Jun 30, 1989 · N56759 · DestroyedNTSB NYC89LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Southampton, MAImproper maintenance which resulted in a section of the vertical stabilizer failing inflight.Jun 30, 1989 · N8462S · Substantial damageNTSB MKC89GA147Accident · 2 fatalFinal reportMaule MX-7 · Atlantic, IAFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which led to an inadvertent stall and loss of control. A contributing factor was the lack of altitude to recover from a stall.Jun 30, 1989 · N6131M · Substantial damageNTSB LAX89FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Cordes, AZThe pilot misjudged his altitude, while maneuvering at low altitude over mountainous terrain. Factors related to the accident were: high density altitude, mountainous terrain, and diversion of the pilot's attention.Jun 30, 1989 · N5199Q · DestroyedNTSB FTW89DRD10Accident · 1 fatalFinal reportGrumman G-164-B · Mer Rouge, LAThe failure of the individual struck by the taxiing airplane's propeller to visually perceive and avoid the airplane.Jun 30, 1989 · N8341K · No damageNTSB DEN89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Telluride, COThe pilot's failure to maintain aircraft control during an encounter with turbulence. Contributing to the accident was the turbulence.Jun 30, 1989 · N82908 · Substantial damageNTSB CHI89LA126Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Sebewaing, MIPilot's inattentive aircraft handling which resulted in his failure to detect and prevent the aircraft's descent into the wheat field.Jun 30, 1989 · N2154K · Substantial damageNTSB BFO89LA050Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Weirton, WVLoss of engine power due to water in the fuel and inadequate preflight inspection of the airplane by the pilot.Jun 30, 1989 · N1950Y · DestroyedNTSB ANC89LA110Accident · Minor injuriesLimited investigationFinal reportMaule M-4-2205 · Beluga, AKThe pilot's failure to properly correct for a crosswind during landing which resulted in a loss of control.Jun 30, 1989 · N40676 · Substantial damageNTSB SEA89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Orchards, WAThe failure of the pilot to align the aircraft with the landing runway on touchdown and his failure to maintain directional control during landing ground roll, resulting in a ground loop.Jun 29, 1989 · N8986C · Substantial damageNTSB NYC89DHA01Accident · No injuriesFinal reportVehafric Jungster ONE · Reading, PAThe failure of the pilot to properly use carburetor heat.Jun 29, 1989 · N17537 · Substantial damageNTSB MIA89WA179Accident · Minor injuriesForeign investigationPiper PA-23-250 · Walker Cay, BahamasJun 29, 1989 · N14038 · Substantial damageNTSB LAX89LA227Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Julian, CAThe failure of the pilot to select the proper runway for existing wind conditions and to execute a go-around when touchdown at the proper point was not accomplished.Jun 29, 1989 · N23687 · Substantial damageNTSB LAX89LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Haleiwa, Oahu, HIThe pilot's failure to adequately compensate for wind conditions and the failure to maintain sufficient altitude to clear obstacles. Contributing to the accident were the downdrafts along the ridge line.Jun 29, 1989 · N2059T · Substantial damageNTSB DEN89FA154Accident · 2 fatalField investigationFinal reportCessna 310Q · Crestone, COImproper in-flight planning/decision by the pilot and his failure to attain sufficient altitude to safely clear the mountains. Contributing factors were: mountainous terrain, box canyon, and high density altitude.Jun 29, 1989 · N7509Q · DestroyedNTSB ATL89FA171Accident · 2 fatalField investigationFinal reportDassault-Breguet Falcon 20 · Cartersville, GAFailure of the pilot-in-command (PIC) to assure that the aircraft maintained a climb profile after takeoff. Factors related to the accident were: dark night, the crew's lack of visual perception at night, the pic's lack of rest (fatigue), and the copilot's…Jun 29, 1989 · N125CA · DestroyedNTSB ATL89DKG04Accident · 1 fatalFinal reportAir Tractor AT-301 · Americus, GAThe pilot's failure to properly survey the area in which he would be conducting aerial application flights and his failure to see and avoid powerlines while performing aerial application.Jun 29, 1989 · N8773S · DestroyedNTSB ANC89LA109Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Kenai, AKFailure of the pilot to obtain proper assistance in starting the engine and/or his inadequate supervision. The passenger's lack of familiarity with the aircraft resulted in her improper use of the throttle which contributed to the accident.Jun 29, 1989 · N5302W · Substantial damageNTSB ANC89LA108Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Bear Creek No.1, AKThe pilot's inproper recovery from a bounced landing which resulted in a loss of directional control. Contributing to the accident was the pilots overconfidence in personal ability, the gusty crosswind conditions and the sunglare.Jun 29, 1989 · N3902G · Substantial damageNTSB SEA89LA125Accident · No injuriesLimited investigationFinal reportMaule M4-210 · Lopez, WAThe pilot did not maintain directional control of the airplane during the landing roll.Jun 28, 1989 · N4744T · Substantial damageNTSB MKC89LA146Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Lonoke, ARPartial failure of the power-plant for undetermined reasons.Jun 28, 1989 · N3653M · Substantial damageNTSB MKC89LA145Accident · 1 fatalLimited investigationFinal reportCessna U206 · Eveleth, MNThe pilot's improper flare during the water landing. The pilot's lack of recent experience in seaplane operations and the lack of experience in the accident aircraft contributed to the accident.Jun 28, 1989 · N9627G · Substantial damageNTSB ANC89LA105Accident · No injuriesLimited investigationFinal reportHelio H800 · King Salmon, AKThe pilot selected unsuitable terrain for the landing. Soft/wet (muddy) terrain conditions were contributing factors.Jun 28, 1989 · N4104D · Substantial damageNTSB FTW89DRG08Accident · No injuriesFinal reportAir Tractor AT-301 · Rio Hondo, TXImproper compensation for wind conditions by the pilot. Factors related to the accident were the adverse wind conditions.Jun 27, 1989 · N4448S · Substantial damageNTSB ANC89LA104Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Iliamna, AKPilot failed to maintain directional control during the attempted go-around. Factors in the accident were the rough/uneven terrain and the brush beside the runway.Jun 27, 1989 · N37209 · Substantial damageNTSB SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Jun 26, 1989 · N22137 · Substantial damageNTSB SEA89FA122Accident · No injuriesField investigationFinal reportDouglas DC-3C · Petersburg, AKThe pilot's improper decision to ditch the aircraft when it could have been flown back to the airport using the right seat controls. Contributing factor(s) was: the failure & separation of a portion of the right aileron fabric, and the pilot's excessive force…Jun 26, 1989 · N8042X · Substantial damageNTSB MKC89LA144Accident · No injuriesLimited investigationFinal reportCessna 210 · Kaiser, MOFailure of the pilot to extend the landing gear. A factor in the accident was the pilot's failure to use the checklist.Jun 26, 1989 · N9440T · Substantial damageNTSB MIA89FA178Accident · 1 fatalField investigationFinal reportBeech A36 · Shelby, MSFailure of the pilot to maintain adequate airspeed while maneuvering back to the runway which resulted in an inadvertentstall. Contributing factors were: failure of the pilot to insure the cabin door (on the passenger's side) was properlyclosed and secured…Jun 26, 1989 · N1837N · Substantial damageNTSB LAX89LA235Accident · No injuriesLimited investigationFinal reportCessna 172E · Mariposa, CAStudent pilot's miscalculation of the fuel supply which led to a loss of engine power due to fuel exhaustion.Jun 26, 1989 · N7744U · Substantial damageNTSB FTW89LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-601B · Cleveland, TXA loss of engine power, due to fuel starvation because the plt misjudged his fuel supply and distribution of fuel per tanks, and as a result mismanaged the supply remaining.Jun 26, 1989 · N601MF · Substantial damageNTSB FTW89DQG04Accident · No injuriesFinal reportCessna A188B · Vega, TXThe unfavorable wind condition (probable whirlwind or severe wind shear) that was encountered moments after lift-off.Jun 26, 1989 · N4956Q · Substantial damageNTSB DEN89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Durango, COThe pilot failed to maintain directional control, which resulted in an inadvertent groundloop/swerve. A factor related to the accident was: the adverse wind condition.Jun 26, 1989 · N4137Z · Substantial damageNTSB CHI89LA121Accident · No injuriesLimited investigationFinal reportCessna C172M · Wadsworth, OHPilot's poor planning/decision making during the approach and landing phase of flight, which resulted in a long landing and runway overrun.Jun 26, 1989 · N19950 · Substantial damageNTSB BFO89IA047Incident · No injuriesIncident investigationFinal reportBritish Aerospace 3101 · Baltimore, MDFailure of maintenance personnel to properly torque the power connection at the air conditioning system fuse.Jun 26, 1989 · N849JS · Minor damageNTSB ATL89LA172Accident · Serious injuriesLimited investigationFinal reportBoeing 737-291 · Atlanta, GAFailure of the ground employee to follow normal safety procedures. His lack of familiarity with the operation was a related factor.Jun 26, 1989 · N7375F · No damageNTSB ANC89LA107Accident · No injuriesLimited investigationFinal reportCessna 180H · Naknek, AKThe pilot's selection of an unsuitable landing area.Jun 26, 1989 · N2435F · Substantial damageNTSB FTW89FA117Accident · 2 fatalField investigationFinal reportCessna 152 · Fort Worth, TXThe inadvertent stall of the airplane by the pilot. Factors contributing to the accident were the pilot's disregard of the weather advisory, the unfavorable windshift, and the thunderstorm outflow.Jun 25, 1989 · N24795 · DestroyedNTSB DEN89LA147Accident · No injuriesLimited investigationFinal reportBeech A24R · Evanston, WYThe pilot became disoriented and delayed in taking remedial action, which resulted on a critically low fuel level. A factor related to the accident was: rough/uneven terrain in the emergency landing area.Jun 25, 1989 · N24607 · Substantial damageNTSB CHI89DEP12Accident · Serious injuriesFinal reportSchuning/Teratorn Terra II · New Berlin, WIFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall.Jun 25, 1989 · N87KS · Destroyed