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 LAX90LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Stockton, CAThe failure of the pilot to maintain control of the aircraft.NTSB 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.NTSB BFO90LA038Accident · No injuriesLimited investigationFinal reportCessna 150G · Clinton, MDPilot factor in that he improperly used the engine controls.NTSB 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.NTSB 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.NTSB MIA90WA116Accident · 1 fatalForeign investigationRyan, Robert R. Glasair · Orangewalk Town, BelizeNTSB 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.NTSB 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.NTSB CHI90LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Bad Axe, MITotal failure of the powerplant during the final approach for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB BFO90FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Ona, WVThe improperly set stabilator trim and the improperly loaded aircraft.NTSB 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.NTSB ATL90LA102Accident · No injuriesLimited investigationFinal reportCessna 170 · Johnson City, TNThe pilot/mechanic's inadequate preflight inspection of the aircraft fuel system.NTSB ATL90LA101Accident · No injuriesLimited investigationFinal reportCessna 177B · Spartanburg, SCThe pilot's improper flare and improper recovery from a bounced landing.NTSB 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…NTSB MIA90WA108Accident · No injuriesForeign investigationPiper PA-28-140 · St.Maarten, NTNTSB 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.NTSB 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.NTSB DEN90LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Edgemont, SDThe failure of the pilot to maintain directional control during the landing rollout.NTSB ANC90LA063Accident · No injuriesLimited investigationFinal reportBell 206B3 · Williamsport, AKThe manufacturer's inadequate part design and the improper maintenance techniques by the operator.NTSB SEA90LA069Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Minden, NVThe pilot's poor inflight planning and decision.NTSB 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.NTSB 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.NTSB FTW90DRA04Accident · No injuriesFinal reportGrumman 164A · Garwood, TXFailure of the number 8 cylinder.NTSB 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.NTSB CHI90FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-30B · Charlevoix, MIThe probable cause of this accident is undetermined.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bridgeport, CTThe pilot failed to maintain directional control during a crosswind landing.NTSB 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.NTSB MKC90LA094Accident · No injuriesLimited investigationFinal reportBennett KR-1 · Blytheville, ARImproper handling of the aircraft during a high speed taxi.NTSB 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.NTSB MKC90LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Salina, KSFuel exhaustion, fuel calculations misjudged and refueling not performed by the pilot in command.NTSB 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.NTSB 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.NTSB FTW90DRD06Accident · Serious injuriesFinal reportStolt Acroduster II · Alexandria, LAThe pilot misjudged the landing flare.NTSB 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.NTSB 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.NTSB 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.NTSB BFO90LA035Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Frederick, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB SEA90TL#02Accident · Serious injuriesClass 3Final reportHiller UH-12E · Elkton, ORNTSB MKC90LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Two Harbors, MNPilot factor in that he failed to maintain flying speed.NTSB 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.NTSB 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.NTSB 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.