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 CHI91LA215Accident · No injuriesLimited investigationFinal reportCessna 182A · Menomonee Falls, WIThe fatigue induced propeller blade failure. A related factor was the operator's delayed propeller overhaul.Jul 5, 1991 · N4735D · Substantial damageNTSB CHI91LA214Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Sparta, MIInadequate preflight by the pilot and the pilot's failure to reach a proper touchdown point.Jul 5, 1991 · N87169 · Substantial damageNTSB CHI91LA210Accident · 2 fatalLimited investigationFinal reportCessna 150F · Faulkton, SDAn inadvertent stall. A factor related to the accident was the pilot's failure to maintain airspeed.Jul 5, 1991 · N6263R · DestroyedNTSB CHI91DER12Accident · Serious injuriesFinal reportLacey B D4 · Albert Lea, MNThe pilot's failure to take adequate remedial action. Related factors are the tall grass runway conditions, and the inadequate airspeed.Jul 5, 1991 · N363H · DestroyedNTSB BFO91LA064Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berlin, MDThe unsuitable placement of two banners (improper planning) by other personnel causing an unintentional pickup of both banners.Jul 5, 1991 · N5BJ · Substantial damageNTSB ANC91LA096Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · King Salmon, AKThe forced landing on the rough terrain and the engine power loss due to the failure of the engine collector intermediate bearings.Jul 5, 1991 · N5538G · Substantial damageNTSB SEA91LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Milford, UTFuel exhaustion, and the pilot's misjudgment of proper descent rate. Factors include inadequate preflight planning, poor in-flight decision, becoming lost/disoriented, and a fence.Jul 4, 1991 · N816CB · Substantial damageNTSB SEA91LA154Accident · 1 fatalLimited investigationFinal reportJerrell RV-4 · Yellowstonepark, WYA collapsed induction air duct. Factors include inadequate design by the manufacturer/builder, and a misjudged rate of descent by the pilot.Jul 4, 1991 · N44AZ · Substantial damageNTSB SEA91LA153Accident · Minor injuriesLimited investigationFinal reportDerego Avid Flyer/B · Myrtle Creek, ORLoss of engine power for an undetermined reason.Jul 4, 1991 · N220B · Substantial damageNTSB SEA91LA150Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Riverton, WYThe pilot did not maintain adequate terrain clearance. A factor to the accident was: poor inflight planning/preparation.Jul 4, 1991 · N2070J · Substantial damageNTSB NYC91LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Rutland, VTThe student pilot improper recovery from a bounced landing which resulted in the collapsing of the nose gear. A factor related to the accident was the student pilot's lack of total flight experience.Jul 4, 1991 · N69061 · Substantial damageNTSB NYC91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAImproper use of the flight controls by the pilot which resulted in an inadvertent stall on takeoff with insufficient altitude for recovery. Factors related to the accident was the failure of the pilot to properly set the elevator trim prior to takeoff and the…Jul 4, 1991 · N7315D · Substantial damageNTSB LAX91LA286Accident · No injuriesLimited investigationFinal reportCessna 150K · Flagstaff, AZThe pilot-in-command's improper preflight planning of fuel requirements to accomplish the intended flight which resulted in an inadequate fuel supply and subsequent loss of engine power. A factor was the fence.Jul 4, 1991 · N64556 · Substantial damageNTSB FTW91LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Lakeview, AR(1) The pilot's failure to properly flare the airplane for landing and (2) his subsequent improper recovery from a bounced landing.Jul 4, 1991 · N64344 · Substantial damageNTSB FTW91DRA05Accident · 1 fatalFinal reportDaniel La Lee Miget Mustang M-1 · Santa Fe, TXThe pilot's performance of an aerobatic maneuver at an altitude inadequate to allow for safe recovery.Jul 4, 1991 · N20LL · DestroyedNTSB FTW91DQG01Accident · 1 fatalFinal reportLGS CGS Hawk · Crane, TXThe inadvertent stall.Jul 4, 1991 · UNREG · DestroyedNTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.Jul 4, 1991 · N40DP · Substantial damageNTSB CHI91LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hill City, SDPoor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.Jul 4, 1991 · N1844G · Substantial damageNTSB CHI91LA207Accident · No injuriesLimited investigationFinal reportHughes 300C · Whitehall, MIThe pilot's failure to maintain adequate clearance from the water. A factor was the dark night light condition.Jul 4, 1991 · N58404 · Substantial damageNTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.Jul 4, 1991 · N503DB · Substantial damageNTSB BFO91LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · New Market, VAThe pilot's inadequate inflight decision that resulted in VFR flight into IMC.Jul 4, 1991 · N63817 · DestroyedNTSB BFO91LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172 · South Boston, VAThe lost of engine power for undetermined reasons and the lack of suitable terrain to make a forced landing.Jul 4, 1991 · N1378U · Substantial damageNTSB ATL91LA123Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Alma, GATurbulence in clouds, which was associated with a dissipating thunderstorm.Jul 4, 1991 · N605DL · No damageNTSB ANC91LA089Accident · No injuriesLimited investigationFinal reportCessna 170B · Prospect Creek, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his delay in reversing course (remedial action). The terrain and weather conditions were related factors.Jul 4, 1991 · N3158A · Substantial damageNTSB ANC91GA087Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot inadvertently switched the magnetos off during the flight. Contributing to the accident was the rough, uneven terrain with loose gravel.Jul 4, 1991 · N82732 · Substantial damageNTSB SEA91LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Waldron, WAVisual lookout was not maintained, and diverted attention.Jul 3, 1991 · N737BZ · Substantial damageNTSB SEA91LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Richland, WAPartial engagement of the parking brake (locking the right brake) for an undetermined reason.Jul 3, 1991 · N757MA · Substantial damageNTSB FTW91LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · El Paso, TXThe power loss due to carburetor icing and the pilot's failure to use carburetor heat. Factors were the icing conditions, lack of suitable terrain for the forced landing, and the gusty tail wind.Jul 3, 1991 · N5488K · Substantial damageNTSB CHI91LA206Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlos, MNThe pilot's failure to use adequate carburetor heat. Factors to the accident were the carburetor icing conditions and the wires.Jul 3, 1991 · N50637 · Substantial damageNTSB ANC91LA082Accident · No injuriesLimited investigationFinal reportCessna 185F · Farewell, AKThe pilot-in-command's failure to maintain directional control during the landing roll. Factors relating to the accident were the collapsed left main landing gear, failed left brake, and the low level of hydraulic brake fluid.Jul 3, 1991 · N222WH · Substantial damageNTSB SEA91LA151Accident · No injuriesLimited investigationFinal reportBeech C33A · Brookings, ORThe pilot's improper flare for touchdown, and her improper recovery from a bounced landing.Jul 2, 1991 · N12EM · Substantial damageNTSB NYC91LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rhinebeck, NYThe pilot did not calculated the airplane's performance data to insure that he had enough runway to clear an obstacle at the end of the field, which resulted in the airplane's landing gear striking high hedges, subsequently the pilot elected to land in a…Jul 2, 1991 · N5002F · Substantial damageNTSB NYC91LA166Accident · Minor injuriesLimited investigationFinal reportCessna C-172 · Clarence Center, NYFailure of the pilot to maintain airspeed during a heavy weight takeoff, resulting in a stall and landing in rough terrain.Jul 2, 1991 · N733FB · DestroyedNTSB NYC91LA164Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300-605R · Newark, NJThe inadvertent encounter with in-flight turbulence, resulting in serious injuries to a crewmember and a passenger.Jul 2, 1991 · N41063 · No damageNTSB NYC91LA163Accident · No injuriesLimited investigationFinal reportLearjet LR25B-XR · Columbus, OHThe failure of the pilot to maintain visual reference with the runway during a landing, which resulted in a loss of directional control. Also causal to the accident was the pilot's failure to initiate a go-around, after he lost sight of the runway during the…Jul 2, 1991 · N458J · Substantial damageNTSB NYC91IA165Incident · No injuriesIncident investigationFinal reportBoeing 727-254 · Buffalo, NYChaffing fire detector loop on the number one engine.Jul 2, 1991 · N913TS · No damageNTSB FTW91LA114Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Marfa, TXThe pilot misjudged the approach. Factors were the high density altitude, the downdraft, and the dteriorted climb performance.Jul 2, 1991 · N9999R · Substantial damageNTSB CHI91LA205Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Savoy, ILThe pilot's failure to maintain tail rotor clearance from the ground. A related factor is the pilot's lack of total experience in helicopters.Jul 2, 1991 · N94515 · Substantial damageNTSB ATL91LA122Accident · No injuriesLimited investigationFinal reportLearjet 23 · Columbia, TNThe pilot's premature decision to turn off the anti-skid during landing roll. Factors to this accident were hydroplaning conditions.Jul 2, 1991 · N500FM · Substantial damageNTSB ATL91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lebanon, TNThe pilot's excessive touchdown speed, his failure to maintain a proper touchdown point, and his failure to execute a go-around when a safe landing could not be made. Factors in the accident were: the wet runway conditions at the airport and the crosswind…Jul 2, 1991 · N3068B · Substantial damageNTSB ANC91LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Cordova, AKThe pilot's failure to maintain directional control during the takeoff ground run and the intentional ground loop by the pilot. The crosswind was a factor in the accident.Jul 2, 1991 · N2765D · Substantial damageNTSB SEA91LA147Accident · No injuriesLimited investigationFinal reportLet L-13 · Driggs, IDThe pilot misjudged his distance and altitude to the runway during the approach and failed to attain the proper touchdown point for landing. His lack of experience in the make and model of glider was a related factor.Jul 1, 1991 · N711KR · Substantial damageNTSB NYC91LA162Accident · No injuriesLimited investigationFinal reportMaule M6-235 · Arcade, NYThe failure of the pilot to attain the proper lift-off speed during a takeoff on a grass runway, resulting in a loss of control and collision with power lines. A factor related to the accident was the pilot's lack of understanding of the airplane's…Jul 1, 1991 · N43LH · Substantial damageNTSB NYC91LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Nayville, NYFailure of the pilot to attain adequate airspeed to climb, which resulted in a stall/mush. The trees were a related factor.Jul 1, 1991 · N8670D · Substantial damageNTSB NYC91DFJ01Accident · 1 fatalFinal reportSterns Sterns Longster · Mayville, NYThe failure of the pilot to maintain airspeed, which resulted in a stall and spin at a low altitude. Also causal to the accident was the lack of experience of the pilot in this make and model airplane.Jul 1, 1991 · N891DS · DestroyedNTSB LAX91LA284Accident · No injuriesLimited investigationFinal reportBeech E-55 · Bakersfield, CAThe pilot's improper use of the landing gear retraction by selecting gear up instead of flaps up during the landing roll-out. Contributing to the accident was the lack of familiarity with the airplane.Jul 1, 1991 · N7268R · Substantial damageNTSB DEN91LA095Accident · No injuriesLimited investigationFinal reportBell 412 · Grand Junction, COThe pilot's failure to maintain adequate main rotor RPM prior to touchdown. Factors were: the disconnected engine to transmission drive shaft and the inadequate inspection by company maintenance personnel.Jul 1, 1991 · N20703 · Substantial damageNTSB DEN91LA094Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot misjudging his flare.Jul 1, 1991 · N89900 · Substantial damageNTSB CHI91LA204Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Dexter, MIThe pilot's delay in aborting the landing. A factor in the accident was his excessive speed on final approach.Jul 1, 1991 · N5713L · DestroyedNTSB BFO91FA061Accident · 1 fatalField investigationFinal reportMooney M20J · Waynesboro, VAThe pilots failure to maintain aircraft control which resulted in overstress of the airplane. Contributing was VFR flight into IMC and thunderstorms.Jul 1, 1991 · N5809J · Destroyed