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 LAX90LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Stockton, CAThe failure of the pilot to maintain control of the aircraft.Apr 23, 1990 · CFUKM · Substantial damageNTSB DEN90LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bountiful, UTThe flight instructor's inadequate supervision of the dual student. Factors in the accident were the premature lift-off by dual student, the rough terrain and the fence.Apr 23, 1990 · N8126W · Substantial damageNTSB BFO90LA038Accident · No injuriesLimited investigationFinal reportCessna 150G · Clinton, MDPilot factor in that he improperly used the engine controls.Apr 23, 1990 · N8689J · Substantial damageNTSB ATL90DMG02Accident · No injuriesFinal reportHardy RV-4 · Kitty Hawk, NCThe pilot's inadequate compensation for wind conditions, and his failure to maintain control of the aircraft.Apr 23, 1990 · N891LH · Substantial damageNTSB NYC90LA090Accident · No injuriesLimited investigationFinal reportEnstrom 280 · Thornton, PAFailure to attain a proper climb rate after takeoff from a confined area. Factors include gusty winds and high obstructions.Apr 22, 1990 · N493H · Substantial damageNTSB MIA90WA116Accident · 1 fatalForeign investigationRyan, Robert R. Glasair · Orangewalk Town, BelizeApr 22, 1990 · N388RR · DestroyedNTSB FTW90LA099Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Danbury, TXPilot in command's failure to see and avoid wires during the final stage of an approach to a confined area. A contributing factor to the accident was the pilot's disregard of the operator's instructions after he landed the first time.Apr 22, 1990 · N287Q · Substantial damageNTSB DEN90LA096Accident · No injuriesLimited investigationFinal reportCessna 170B · Englewood, COThe pilot's failure to maintain directional control of the airplane during the landing. The crosswind condition was a factor related to the accident.Apr 22, 1990 · N8074A · Substantial damageNTSB CHI90LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Bad Axe, MITotal failure of the powerplant during the final approach for undetermined reasons.Apr 22, 1990 · N6369W · Substantial damageNTSB CHI90LA116Accident · No injuriesLimited investigationFinal reportBeech E 55 · New Richmond, WIPilot's improper use of the landing gear mechanism during the landing roll, which resulted in the partial collapse of the landing gear.Apr 22, 1990 · N17577 · Substantial damageNTSB CHI90DEE05Accident · Minor injuriesFinal reportDan T. Zelazo Avid/Speedwing · Sandwich, ILImproper installation of a fuel line by the p. lot/manufacturer which resulted in separation of a fuel line, resulting in fuel starvation.Apr 22, 1990 · N396DZ · Substantial damageNTSB BFO90LA037Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Prnc Frederick, MDThe pilot's improper planning/decision by not shutting down the engine or assuring the helicopter was properly attended,when he deplaned.Apr 22, 1990 · N2580E · Substantial damageNTSB BFO90FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Ona, WVThe improperly set stabilator trim and the improperly loaded aircraft.Apr 22, 1990 · N5886U · DestroyedNTSB ATL90LA104Accident · No injuriesLimited investigationFinal reportBalloon Works 7B · Lexington, KYThe overload failure of several jumper cords. Factor(s) were inadvertent encounter with unfavorable wind (dust devil). Subsequently, the pilot was unable to control the rate of descent.Apr 22, 1990 · N1512T · Substantial damageNTSB ATL90LA102Accident · No injuriesLimited investigationFinal reportCessna 170 · Johnson City, TNThe pilot/mechanic's inadequate preflight inspection of the aircraft fuel system.Apr 22, 1990 · N3980V · Substantial damageNTSB ATL90LA101Accident · No injuriesLimited investigationFinal reportCessna 177B · Spartanburg, SCThe pilot's improper flare and improper recovery from a bounced landing.Apr 22, 1990 · N19119 · Substantial damageNTSB MKC90LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Eldora, IAImproper planning/decision by the pilot, and his failure to maintain clearance from obstructions during the approach to land. Factors related to the accident were: the aircraft's low fuel level, darkness, the pilot's selection of the wrong airport/runway, the…Apr 21, 1990 · N1680P · Substantial damageNTSB MIA90WA108Accident · No injuriesForeign investigationPiper PA-28-140 · St.Maarten, NTApr 21, 1990 · N970CA · DestroyedNTSB DEN90LA098Accident · No injuriesLimited investigationFinal reportCessna 310B · Elizabeth, COThe pilot's attempt to takeoff with a known deficiency and the partial failure of the propeller feathering system.Apr 21, 1990 · N6641B · Substantial damageNTSB DEN90LA097Accident · Minor injuriesLimited investigationFinal reportAvions Mudry CAP10B · Grand Forks, NDAn over temperature of the inlet fuel line resulting in fuel starvation (vapor lock) in the fuel injection system. A factor in the accident was the lack of a suitable landing area.Apr 21, 1990 · N64UV · Substantial damageNTSB DEN90LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Edgemont, SDThe failure of the pilot to maintain directional control during the landing rollout.Apr 21, 1990 · N8528D · Substantial damageNTSB ANC90LA063Accident · No injuriesLimited investigationFinal reportBell 206B3 · Williamsport, AKThe manufacturer's inadequate part design and the improper maintenance techniques by the operator.Apr 21, 1990 · N1075G · Substantial damageNTSB SEA90LA069Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Minden, NVThe pilot's poor inflight planning and decision.Apr 20, 1990 · N1065F · DestroyedNTSB NYC90LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Marshfield, MAThe pilots failure to maintain directional control during an aborted landing. Factors related to the accident were: the pilots limited experienced in type of airplane, and variable winds.Apr 20, 1990 · N2184N · Substantial damageNTSB FTW90FA097Accident · 1 fatalField investigationFinal reportBeech 58 · Dallas, TXThe pilot's improper use of the fuel boost pumps for take, and his failure to maintain airspeed above the minimum single engine control speed (VMC), which resulted in a loss of aircraft control.Apr 20, 1990 · N770X · DestroyedNTSB FTW90DRA04Accident · No injuriesFinal reportGrumman 164A · Garwood, TXFailure of the number 8 cylinder.Apr 20, 1990 · N5295 · Substantial damageNTSB CHI90LA115Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Milwaukee, WIThe utilization of improper procedures on the part of the pilot in command by attempting to execute a coupled approach outside the parameters of the autopilot.Apr 20, 1990 · N179DD · Substantial damageNTSB CHI90FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-30B · Charlevoix, MIThe probable cause of this accident is undetermined.Apr 20, 1990 · N8333Y · DestroyedNTSB ATL90FA100Accident · 1 fatalField investigationFinal reportBell 205A-1 · Moncks Corner, SCThe in-flight separation of the main rotor because of the failure of a pillow block bolt, and the failure of the operator/repair station to follow the overhaul procedures.Apr 20, 1990 · N67HJ · DestroyedNTSB NYC90LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Blossvale, NYFailure of the pilot to maintain directional control during landing. Factors related to the accident were: a gusty quartering tailwind.Apr 19, 1990 · N2275E · Substantial damageNTSB MKC90LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Des Arc, ARWater contamination of the fuel, due to improper ground servicing of the aircraft, and an improper preflight by the pilot.Apr 19, 1990 · N8139K · Substantial damageNTSB MIA90FA107Accident · 3 fatalField investigationFinal reportCessna 177B · North Captiva, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.Apr 19, 1990 · N30962 · DestroyedNTSB LAX90DUG05Accident · 1 fatalFinal reportGrumman G-164B · Blythe, CAFailure of the pilots of N6708K and N10222 to maintain adequate visual lookout and failure of the pilot of N6708K to follow a prearanged procedure for reversing the direction of flight.Apr 19, 1990 · N6708K · 2 aircraft · DestroyedNTSB NYC90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bridgeport, CTThe pilot failed to maintain directional control during a crosswind landing.Apr 18, 1990 · N132CP · Substantial damageNTSB NYC90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · New Castle, PAInadequate supervision of the student pilot by the flight instructor which resulted in a hard landing. Factors related to the accident was the improper use of the flight controls by a student pilot.Apr 18, 1990 · N48259 · Substantial damageNTSB MKC90LA094Accident · No injuriesLimited investigationFinal reportBennett KR-1 · Blytheville, ARImproper handling of the aircraft during a high speed taxi.Apr 18, 1990 · N31123 · Substantial damageNTSB MKC90LA088Accident · Serious injuriesLimited investigationFinal reportBell 47 · Oakdale, MNA slipping rotor drive clutch assembly due to improper maintenance by company personnel. Contributing factors were static wires in the path.Apr 18, 1990 · N5120B · Substantial damageNTSB MKC90LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Salina, KSFuel exhaustion, fuel calculations misjudged and refueling not performed by the pilot in command.Apr 18, 1990 · N714EB · Substantial damageNTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.Apr 18, 1990 · N91309 · DestroyedNTSB LAX90FA148Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-10F · Los Angeles, CAPilot failed to adhere to established landing procedures, maintain a stabilized approach, and allowed the airspeed to go below the predicted v.Apr 18, 1990 · N68056 · Substantial damageNTSB FTW90DRD06Accident · Serious injuriesFinal reportStolt Acroduster II · Alexandria, LAThe pilot misjudged the landing flare.Apr 18, 1990 · N63BD · DestroyedNTSB DEN90LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbia Falls, MTThe pilot's failure to preflight and secure the fuel cap which resulted in the loss of fuel and the loss of engine power from fuel exhaution. Factor was soft terrain during forced landing.Apr 18, 1990 · N3233L · Substantial damageNTSB CHI90LA114Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Sheboygan, WIFailure of the pilot to complete the landing checklist and lower the landing gear. Contributing to this accident is habit pattern interference and distraction.Apr 18, 1990 · N57175 · Substantial damageNTSB CHI90LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Franklin, INThe pilot's improper planning/decision in choosing to continue flight to the destination airport without refueling. The dark night conditions, and a known intermittent radio problem were contributing factors.Apr 18, 1990 · N4698Z · Substantial damageNTSB BFO90LA035Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Frederick, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.Apr 18, 1990 · N71231 · Substantial damageNTSB SEA90TL#02Accident · Serious injuriesClass 3Final reportHiller UH-12E · Elkton, ORApr 17, 1990 · N5354V · DestroyedNTSB MKC90LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Two Harbors, MNPilot factor in that he failed to maintain flying speed.Apr 17, 1990 · N4020J · Substantial damageNTSB MKC90FA091Accident · 2 fatalField investigationFinal reportPiper PA32RT-300 · Mansfield, ARThe non-instrument rated pilot's decision to continue VFR flight into IMC. Contributing to the accident were the low ceilings, rain, and turbulence encountered at low altitude, and the pilot's lack of instrument training/experience.Apr 17, 1990 · N2208N · DestroyedNTSB LAX90LA150Accident · No injuriesLimited investigationFinal reportPiper PA46 · Paso Robles, CAInadequate altitude for proper landing gear extension; not ensuring the landing gear was down and locked; complacency of the certified flight instructor.Apr 17, 1990 · N4387S · Substantial damageNTSB LAX90LA147Accident · No injuriesLimited investigationFinal reportBeech F-33A · Goodyear, AZThe pilot's failure to follow directives and his misjudgement of distance. Contributing to the accident was the airport management's failure to ensure that the building did not pose a hazard.Apr 17, 1990 · N6508V · Substantial damage