Final NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE c.\"completionStatus\" = 'Completed' 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 WHERE c."completionStatus" = 'Completed' 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 WPR20LA212Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Lake Tahoe, CAThe partial loss of engine power due to carbon buildup in the No. 4 cylinder resulting from the pilot’s inadequate mixture-leaning procedures.NTSB WPR20LA211Accident · 1 fatalClass 3 · LimitedFinal reportBell UH1H · Payson, AZA flight control malfunction due to either a hydraulic hardover or a flight control stiffness event, which resulted in a loss of control.NTSB CEN20LA268Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20TN · Buena Vista, COThe pilot's distraction during takeoff, which resulted in collision with terrain.NTSB WPR20CA214Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18A-135 · Marion, MTThe pilot's failure to maintain directional control of the airplane while landing in gusting wind conditions, which resulted in a runway excursion and collision with a fence.NTSB WPR20CA213Accident · No injuriesClass 4 · Data collectionFinal reportBeech 33 · Redmond, ORThe left seated flight instructor’s improper manipulation of the landing gear position selection lever to the up position while still on the landing roll, which ultimately resulted in a landing gear collapse during a subsequent landing.NTSB ERA20CA240Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Bardstown, KYThe commercial pilot's exceedance of the airplane's critical angle of attack and subsequent loss of lateral bank control during a soft field takeoff.NTSB CEN20LA267Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Tornado · Mankato, KSA total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20LA266Accident · Serious injuriesClass 3 · LimitedFinal reportLancair ES-P · Pauls Valley, OKThe reason for this accident could not be determined based on the available information.NTSB WPR20LA226Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75 · Chino, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR20FA206Accident · 8 fatalClass 3 · FieldFinal reportCessna TU206 · Coeur d'Alene, IDThe failure of the pilots of both airplanes to see and avoid the other airplane.NTSB WPR20CA205Accident · No injuriesClass 4 · Data collectionFinal reportBeech 23 · Sedona, AZThe pilot's inability to maintain a climb after an attempted takeoff in high density altitude conditions, which resulted in a forced landing on a road and subsequent landing gear collapse.NTSB ERA20CA263Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Prattville, ALThe student pilot's failure improper landing flare, which resulted in a hard landing.NTSB ERA20CA238Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB 10 · Easton, PAThe pilot's failure to maintain a proper glide path, which resulted in landing short of the runway, the airplane’s landing gear contacting the runway lip, and substantial damage to the airplane’s right wing.NTSB DCA22LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Orlando, FLAn encounter with moderate turbulence during descent.NTSB CEN20LA263Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Eveleth, MNThe seizure of the airplane’s engine-driven fuel pump due to internal contamination, which led to a total loss of engine power. The source of the contamination could not be determined based on available evidence.NTSB CEN20LA262Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Ravenna, TXElectrical and engine problems for reasons that could not be determined based on available evidence.NTSB CEN20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCondor Condor · Freedom, WIThe pilot's failure to initiate a climb in a timely manner which resulted in contact with wires.NTSB ANC20LA065Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Anchorage, AKThe failure of the left float bottom due to corrosion, which resulted in a loss of control during the water landing.NTSB WPR20CA208Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20E · Neenah, WIThe pilot's improper landing flare, which resulted in a bounced, hard landing and subsequent runway overrun.NTSB ERA20CA254Accident · No injuriesClass 4 · Data collectionFinal reportLockwood Aircam · Ooltewah, TNThe pilot's failure to maintain directional control during landing.NTSB CEN20LA264Accident · No injuriesClass 3 · LimitedFinal reportMbb BK117 · Wooster, OHThe entanglement of construction fencing into the main rotor system, which necessitated a forced landing that resulted in substantial damage to the helicopter.NTSB CEN20LA261Accident · Minor injuriesClass 3 · LimitedFinal reportEnstrom 280 · Des Moines, IAThe partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…NTSB ANC20LA064Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Soldotna, AKThe delamination of the fabric material from the fuselage above the windscreen due to failed adhesive, which resulted in disrupted airflow and a subsequent hard landing.NTSB ANC20CA066Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Tyonek, AKThe pilot's decision to land at an unimproved airstrip with limited go-around capabilities, his improper landing flare and aborted landing, and his subsequent failure to attain sufficient altitude to clear vegetation during an attempted go-around.NTSB WPR20LA203Accident · 4 fatalClass 3 · LimitedFinal reportCessna 172 · Alpine, UTThe pilot’s exceedance of the airplane’s critical angle-of-attack while maneuvering in a canyon, which resulted in a loss of airplane control.NTSB ERA20LA237Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Titusville, FLThe loss of directional control during landing due to the fracture of the steering horn bolts, which rendered the nosewheel steering ineffective and resulted from the airplane being towed over the left turn limits at an undetermined time before the accident.NTSB CEN20LA287Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Des Arc, ARA total loss of engine power for reasons that could not be determined from all available evidence.NTSB CEN20LA269Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Weldon, ARThe total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.NTSB CEN20LA260Accident · No injuriesClass 3 · LimitedFinal reportChampion 7EC · Port O'Conner, TXThe loss of engine power due to a stuck intake valve.NTSB CEN20LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSopwith Type 9400 · Van Alstyne, TXAn inflight loss of aileron control due to movement of a control connector.NTSB WPR20CA204Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · San Diego, CAThe pilot's failure to maintain airplane control during landing with a crosswind and excessive braking action, which resulted in the airplane nosing over.NTSB ERA20CA241Accident · No injuriesClass 4 · Data collectionFinal reportAviat A1 · Plattsburgh, NYThe pilot's loss of control of the airplane during a water landing after striking a boat wake, which resulted in substantial damage to the fuselage.NTSB ERA20CA239Accident · No injuriesClass 4 · Data collectionFinal reportBeech 76 · Crystal River, FLThe flight instructor's delayed remedial action during a simulated engine failure on takeoff, which resulted in a loss of directional control.NTSB CEN20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Welsh, LAA partial loss of engine power while in flight due to corrosion of engine components, which resulted in a loss of control and a subsequent impact with terrain.NTSB CEN20LA265Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado · Marksville, LAThe student pilot’s failure to ensure sufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion, which resulted in impact with terrain.NTSB CEN20LA258Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Bridgeport, TXMaintenance personnel’s inadequate inspection, which resulted in a total loss of engine power due to a restricted air intake-induction system.NTSB ANC20CA063Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Nikolai, AKThe pilot's improper decision to depart from an unsuitable off-airport surface which resulted in a departure area excursion and impact with trees.NTSB ERA20LA234Accident · 1 fatalClass 3 · LimitedFinal reportEvektor Aerotechnik Sportstar · Ocala, FLThe pilot’s impairment or distraction due to an acute stroke, which resulted in an unstabilized approach and subsequent loss of airplane control during landing.NTSB ERA20CA236Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Meadville, PAThe pilot's distraction while taxiing, which resulted in a taxiway excursion.NTSB ERA20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Chesapeake, VAThe student pilot's improper landing flare and failure to recover from the ensuing bounced landing, which resulted in a runway excursion.NTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB CEN20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18A-150 · Brainerd, MNThe pilot's decision to land on a shortened field and his incorrect brake application. Contributing was the flight instructor's lack of oversight.NTSB WPR20LA201Accident · 1 fatalClass 3 · LimitedFinal reportAvia Stroitel AC-5M · Bend, ORA loss of control just after takeoff for reasons that could not be determined based on the available information.NTSB WPR20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV-8 · McMinnville, ORThe pilot's failure to maintain directional control during takeoff which resulted in a collision with a runway marker.NTSB ERA20CA242Accident · No injuriesClass 4 · Data collectionFinal reportCessna 177 · Pittsfield, MAThe pilot’s improper landing flare, which resulted in a hard, bounced landing, and substantial damage to the airplane’s fuselage.NTSB ERA20CA233Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 8 · Perkasie, PAThe pilot’s loss of directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and collision with a ditch.NTSB ERA20CA231Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · South Bay, FLThe pilot's loss of airplane control during the approach, which resulted in an aerodynamic stall and impact with vegetation and terrain.NTSB WPR20CA197Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Pioche, NVThe pilot’s decision to fly at low level over mountainous terrain and his inability to recover when the helicopter encountered a downdraft that resulted in a collision with terrain.NTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB ANC20CA062Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCK-1865 · Juneau, AKThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.