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 FTW99LA160Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Cleburne, TXThe total loss of engine power resulting from a failure of the #4 cylinder exhaust valve and/or piston. Factors were the dark night conditions and the lack of suitable terrain for the forced landing.Jun 5, 1999 · N4774K · Substantial damageNTSB DEN99FA093Accident · 1 fatalField investigationFinal reportBeech V35A · Nederland, COThe pilot's intentional and continued flight into instrument meteorological conditions. Factors were his failure to obtain a weather briefing, the existing weather conditions that included snow, hail, obscuration and lightning, and the mountainous terrain.Jun 5, 1999 · N68VT · DestroyedNTSB ANC99LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ekwok, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were a crosswind, and an inadvertent ground loop.Jun 5, 1999 · N1195A · Substantial damageNTSB ANC99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's failure to compensate for the wind conditions and maintain a proper rate of descent during the approach for landing, which resulted in a hard landing, and the subsequent collapse of the right main landing gear strut.Jun 5, 1999 · N78456 · Substantial damageNTSB ANC99FA070Accident · 1 fatalField investigationFinal reportCessna A185F · Soldotna, AKThe improper recovery from a bounced water landing by the pilot. Factors associated with this accident were the pilot's failure to release his seatbelt due to the obstructed location of the pilot's seatbelt buckle.Jun 5, 1999 · N61609 · Substantial damageNTSB MIA99LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150M · La Fayette, GAThe improper flare by the student pilot and the inadequate supervision by the pilot in command.Jun 4, 1999 · N3773V · Substantial damageNTSB LAX99LA208Accident · No injuriesLimited investigationFinal reportCulver V · San Martin, CAFuel exhaustion due to the pilot's inadequate in-flight planning and failure to refuel the aircraft during an en route stop.Jun 4, 1999 · N44549 · Substantial damageNTSB FTW99LA159Accident · No injuriesLimited investigationFinal reportLuscombe 8E · New Iberia, LAThe pilot's inadvertent ground loop.Jun 4, 1999 · N2680K · Substantial damageNTSB CHI99LA173Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Effingham, ILinadvertent wheels-up landing and the checklist not followed by the pilot. The landing gear lever not engaged was an additional cause.Jun 4, 1999 · N711NE · Substantial damageNTSB SEA99FA080Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ephrata, WAThe glider pilot's failure to maintain control of his aircraft during spoiler retraction, which led to the Piper pilot's inability to recover safe flying airspeed within the altitude constraints at the time of the event. Contributing factors were the failure…Jun 3, 1999 · N3189Z · DestroyedNTSB NYC99LA132Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jaffrey, NHThe pilot's failure to maintain sufficient rotor rpm. A factor in this accident was the crosswind condition.Jun 3, 1999 · N221DD · Substantial damageNTSB NYC99LA128Accident · Serious injuriesLimited investigationFinal reportCessna T310Q · West Laurens, NYthe pilot's impairment due to hypoxia, which resulted in reduced situational awareness and a power loss due to fuel exhaustion.Jun 3, 1999 · N1273G · Substantial damageNTSB LAX99LA206Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · St. David, AZThe pilot's failure to maintain an adequate reference approach airspeed for the existing gusty wind conditions, and, his improper (uncoordinated) use of the pitch and power controls to arrest the resulting high sink rate.Jun 3, 1999 · N234TT · Substantial damageNTSB LAX99FA207Accident · No injuriesField investigationFinal reportBoeing 757-232 · Phoenix, AZThe pilot's excessive and rapid forward control column movement in response to a bounced landing, which resulted in the hard touchdown of the nose wheel.Jun 3, 1999 · N656DL · Substantial damageNTSB DEN99LA095Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Houston, TXInadequate remedial action by the pilot in command (CFI) after the student failed to maintain control of the aircraft during the final stages of a visual approach to land. Factors were gusting crosswinds and the flight instructor's lack of total instructional…Jun 3, 1999 · N4273E · Substantial damageNTSB CHI99LA172Accident · Minor injuriesLimited investigationFinal reportde Havilland Tiger Moth DH82A · Maize, KSthe pilot's inability to maintain a climb after takeoff as a result of wind shear. Factors associated with the accident were the variable, gusty wind conditions, and the tree which was contacted.Jun 3, 1999 · N9393 · Substantial damageNTSB NYC99LA134Accident · 1 fatalLimited investigationFinal reportSaliba Long EZ · Friendly, MDThe separation of the airplane canopy for undetermined reasons, the diminished controllability of the airplane, and the pilot's failure to maintain airspeed resulting in a stall/mush into trees short of the runway.Jun 2, 1999 · N555L · DestroyedNTSB FTW99LA157Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Monaville, TXThe pilot's failure to touch down on the dry area of the landing strip. A factor was the soft terrain condition on the sides of the grass strip.Jun 2, 1999 · N73PB · Substantial damageNTSB DCA99MA060Accident · 11 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-82 · Little Rock, ARThe flight crew's failure to discontinue the approach when severe thunderstorms and their associated hazards to flight operations had moved into the airport area and the crew's failure to ensure that the spoilers had extended after touchdown. Contributing to…Jun 2, 1999 · N215AA · DestroyedNTSB ANC99LA068Accident · No injuriesLimited investigationFinal reportRobinson R22 · Glennallen, AKThe pilot's failure to maintain rotor RPM during takeoff. Factors associated with the accident were a downdraft, and uneven terrain.Jun 2, 1999 · N1929T · Substantial damageNTSB SEA99LA079Accident · No injuriesLimited investigationFinal reportSnow S2C · Paul, IDThe pilot's inaccurate weight and balance calculations, and his delay in jettisoning the load which resulted in his failure to clear rising terrain. Contributing to the accident was the high density altitude, and the pilot's intentional operation with known…Jun 1, 1999 · N1665S · Substantial damageNTSB FTW99LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Venice, LAThe pilot's improper touchdown procedure, resulting in a main rotor blade contacting the tailboom. Factors were the soft and wet terrain conditions, and the loss of engine power due to the spiral fatigue failure of the gas generator turbine shafting due to…Jun 1, 1999 · N7131U · Substantial damageNTSB DEN99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Parkman, WYThe pilot's inadequate in-flight planning by exceeding the helicopter's performance climb capability. Factors were the downdraft encountered during initial climb following takeoff, and the high density altitude.Jun 1, 1999 · N7052L · Substantial damageNTSB NYC99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructors failure to maintain climb airspeed during the go-around, which degraded climb performance, resulting in an in-flight collision with terrain. Factors in the accident were, delay in executing a go-around, retracting the flaps to 10…May 31, 1999 · N1223F · Substantial damageNTSB LAX99LA203Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Reno, NVFuel starvation resulting from the pilot's inattentive monitoring and management of the fuel system.May 31, 1999 · N37MJ · Substantial damageNTSB FTW99LA158Accident · No injuriesLimited investigationFinal reportCessna 210K · Mountain View, ARThe pilot's failure to maintain control during the landing flare/touchdown. Factors were the pilot's delay in aborting the landing and the fence post.May 31, 1999 · N9483M · Substantial damageNTSB FTW99LA156Accident · No injuriesLimited investigationFinal reportCessna 195 · Conroe, TXThe fatigue fracture of the left main landing gear spring at the clamping mechanism, as a result of fretting.May 31, 1999 · N2151C · Substantial damageNTSB DEN99LA091Accident · Serious injuriesLimited investigationFinal reportCrozier Emeraude · Delta, COThe pilot's failure to maintain directional control. Factors were the gusty tailwind and crosswinds reported, and the pilot's total lack of aeronautical experience.May 31, 1999 · N99PC · Minor damageNTSB CHI99LA169Accident · 1 fatalLimited investigationFinal reportHornbeck Glassair · Johnson City, KSThe pilot's intentional low altitude performance of aerobatics.May 31, 1999 · N83PG · DestroyedNTSB ATL99LA100Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbia, SCThe pilot's failure to maintain directional control during a landing roll.May 31, 1999 · N39PC · Substantial damageNTSB NYC99FA130Accident · Serious injuriesField investigationFinal reportCessna P206B · Piscataway, NJwas a power loss for undetermined reason(s) while operating over unsuitable terrain.May 30, 1999 · N4724F · DestroyedNTSB NYC99FA126Accident · 2 fatalField investigationFinal reportBeech D50C · Montgomery, NYThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin.May 30, 1999 · N401JD · Substantial damageNTSB LAX99LA204Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZThe failure of the tower (local) air traffic controller to issue a landing sequence to the climbing, high wing Cessna 172 aircraft, and, the controller's failure to maintain visual separation between the two aircraft on downwind leg.May 30, 1999 · N66018 · 2 aircraft · Substantial damageNTSB IAD99LA047Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Ocean City, MDWas the pilot leaving the magneto switch in the on position while hand rotating the propeller.May 30, 1999 · N4MF · No damageNTSB IAD99LA046Accident · 1 fatalLimited investigationFinal reportPoskus Revelation · Latrobe, PAWas the pilot's failure to maintain directional control.May 30, 1999 · N2DF · DestroyedNTSB ATL99LA099Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Chapin, SCThe loss of engine power for undetermined reasons. A factor was the collision with a utility wire.May 30, 1999 · N881FD · Substantial damageNTSB ANC99LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot's inadequate compensation for a crosswind. A factor associated with the accident is a crosswind.May 30, 1999 · N8570C · Substantial damageNTSB NYC99LA135Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Bennington, VTThe pilot's inadequate pre-flight briefing which resulted in control interference by the right front seat passenger.May 29, 1999 · N126MC · Substantial damageNTSB NYC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Alliance, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were the crosswind conditions and wind gusts.May 29, 1999 · N9654W · Substantial damageNTSB NYC99LA124Accident · 2 fatalLimited investigationFinal reportToman Great Lakes 2T-1AJ · Painesville, OHThe pilot's improper decision to conduct low-level aerobatic flight, and his lack of adequate altitude for the maneuver attempted.May 29, 1999 · N275J · DestroyedNTSB NYC99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Hillsborough, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of experience in the accident airplane's make and model.May 29, 1999 · N98122 · Substantial damageNTSB NYC99FA123Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · West Dover, VTWas the failure of the pilot to maintain control of the airplane during an aborted landing. Factors were the pilot's lack of familiarity with the airplane, the variable winds, and night conditions.May 29, 1999 · N717AV · DestroyedNTSB LAX99LA202Accident · No injuriesLimited investigationFinal reportBeech D-45 · Lake Berryessa, CALoss of engine power due to a loose adjustment nut on the engine driven fuel pump that allowed for a decrease in fuel flow and fuel pressure, and the subsequent failure of the electric fuel boost pump due to loose bearings decreasing fuel flow and fuel…May 29, 1999 · N20869 · Substantial damageNTSB FTW99FA153Accident · 2 fatalField investigationFinal reportMooney M20B · Mesquite, TXThe failure by both pilots to maintain visual lookout. A factor was the inadequate radio communications maintained by both pilots while in the traffic pattern.May 29, 1999 · N74706 · 2 aircraft · DestroyedNTSB DEN99LA089Accident · Minor injuriesLimited investigationFinal reportDehaan Challenger II · Douglas, WYThe pilot's failure to maintain directional control of the aircraft by not adequately correcting for torque/p-factor during initial climb following takeoff.May 29, 1999 · N22FE · Substantial damageNTSB CHI99LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kalamazoo, MIthe excessive airspeed, the proper touchdown point not obtained and the aborted landing not performed by the pilot. The fence and automobile were contributing factors.May 29, 1999 · N9612Y · Substantial damageNTSB CHI99FA167Accident · 1 fatalField investigationFinal reportChampion 7ECA · Comstock, WIThe pilot's failure to maintain aircraft control. A factor contributing to this accident was the airplane's low altitude.May 29, 1999 · N12028 · DestroyedNTSB ATL99LA098Accident · No injuriesLimited investigationFinal reportPiper PA-60-600 · Montgomery, ALThe pilot's inadvertent shutdown of the wrong engine that resulted in the total loss of engine power. A factor was the loss of engine power due to fuel starvation when the left fuel boost pump failed.May 29, 1999 · N601JS · Substantial damageNTSB ANC99LA066Accident · No injuriesLimited investigationFinal reportde Havilland DHC 2 MK III · Anchorage, AKThe certificated flight instructor's inadequate supervision of the duel student. Factors associated with the accident were the student's inadvertent stall, and a surging turboshaft engine.May 29, 1999 · N30CC · Substantial damageNTSB SEA99FA176Accident · 2 fatalField investigationFinal reportCessna 152 · Coeur d'Alene, IDThe flight crew's failure to maintain adequate airspeed, resulting in a stall and uncontrolled collision with terrain. A factor was mountainous/hilly terrain.May 28, 1999 · N714UZ · Destroyed