NTSB investigations, CA
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA' 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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 WPR20LA135Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-23-250 · Hemet, CAMaintenance personnel’s failure to properly inspect and replace damaged aileron control cables, which resulted in fatigue separation of the aileron control cable and loss of control of the aircraft.NTSB WPR20LA133Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Lodi, CAThe fatigue failure of the no. 4 cylinder connecting rod, which resulted in a total loss of engine power.NTSB WPR20CA132Accident · No injuriesClass 4 · Data collectionFinal reportCook Sonex · Upland, CAA gradual loss of engine power during takeoff due to the pressure regulator not keeping continuous fuel pressure which led to a precautionary off airport landing and collision with terrain.NTSB WPR20CA127Accident · No injuriesData collectionFinal reportFLIGHTstar 2 · Oakdale, CAThe noncertificated pilot’s decision to take off through a large helicopter’s rotor wash, which resulted in his inability to gain altitude during takeoff.NTSB WPR20LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Corona, CAThe pilot's failure to use carburetor heat while operating in conditions conducive to serious carburetor icing, which resulted in a total loss of engine power.NTSB WPR20LA123Accident · 1 fatalClass 3 · LimitedFinal reportCessna TU206 · Auburn, CAThe total loss of engine power after takeoff due to water contamination of the fuel.NTSB WPR20CA174Accident · No injuriesClass 4 · Data collectionFinal reportExtra EA 300 · Concord, CAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop.NTSB WPR20LA117Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Santa Paula, CAThe pilot’s failure to ensure adequate fuel onboard for the planned flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR20CA120Accident · No injuriesData collectionFinal reportPiper PA28R · Palm Springs, CAThe pilot's failure to see and avoid a parked vehicle near the taxiway edge.NTSB WPR20FA108Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Sylmar, CAThe pilot’s spatial disorientation during an instrument approach in instrument meteorological conditions, which resulted in loss of control of the airplane.NTSB WPR20LA101Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Needles, CAA loss of engine power for undetermined reasons due to a lack of available evidence.NTSB WPR20CA105Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Santa Barbara, CAThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a rapid descent rate, hard landing, and nose-over.NTSB WPR20LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · San Jose, CAThe failure to properly service the hydraulic power pack prevented a normal landing gear extension. Contributing to the accident was the failure of the landing gear emergency release valve to function properly for reasons that could not be determined based on…NTSB WPR20CA103Accident · No injuriesData collectionFinal reportCubCrafters FX-3 · Sonoma/Schellville, CAThe pilot's inadvertent activation of the left brake during the landing roll, which resulted in a loss of directional control, a runway excursion, and collision with a ditch.NTSB WPR20LA094Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Torrance, CAThe partial loss of power due to a malfunction of the throttle cable, which limited movement of the throttle body.NTSB WPR20CA093Accident · Minor injuriesData collectionFinal reportAviat A1 · Columbia, CAThe pilot's failure to maintain bank control during landing in gusting wind conditions.NTSB WPR20CA092Accident · No injuriesData collectionFinal reportBell OH 58A · Colexico, CAThe pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.NTSB ENG20LA016Incident · No injuriesClass 3 · LimitedFinal reportAirbus A319 · Sacramento, CAA worn component within each engine integrated drive generator (IDG) resulted in the loss of electrical power supplied to several flight deck displays and systems while on approach to landing. The component, a fixed cylinder block, had significant wearing of…NTSB WPR20CA090Accident · No injuriesData collectionFinal reportBeech 36 · Avalon, CAThe pilot's improper approach and delayed decision to apply corrective action, which resulted in a runway overrun, impact with a berm, and a subsequent nose-over.NTSB WPR20FA086Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Sonora, CAThe pilot’s failure to maintain clearance from trees during approach for landing.NTSB WPR20CA089Accident · Minor injuriesData collectionFinal reportCessna 208 · Eureka, CAThe pilot's delayed response to initiate a go-around during a night visual approach over water after the airplane entered instrument meteorological conditions, which resulted in a loss of forward visibility and subsequent impact with the water.NTSB DCA20IA081Incident · No injuriesClass 3 · IncidentFinal reportAerospatiale AS350BA · Johnson Valley, CAthe failure of the small UAS remote pilot to give way to the helicopter, resulting in an inflight collision. Contributing to the incident was the sUAS remote pilot’s failure to assess and mitigate the risks of operations in close proximity to other aircraft.…NTSB DCA20CA077Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 747 412 · Los Angeles, CAAn unavoidable collision with a garbage dumpster that had blown into the path of the airplane during the takeoff roll.NTSB DCA20WA070Accident · Serious injuriesForeign investigationAirbus A380 · Los Angeles, CAThe General Civil Aviation Authority (GCAA) of the United Arab Emirates has informed the NTSB of an accident involving an Airbus A-380, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist the GCAA investigation…NTSB DCA20MA059Accident · 9 fatalClass 1 · MajorFinal reportSikorsky S76 · Calabasas, CAThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…NTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.NTSB WPR20FA072Accident · 4 fatalClass 3 · FieldFinal reportBeech B36TC · Corona, CAThe pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting.NTSB WPR20CA073Accident · Minor injuriesData collectionFinal reportStearman B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose-over when the right wheel encountered mud.NTSB WPR20CA064Accident · Minor injuriesData collectionFinal reportAirborne XT912 · Hawthorne, CAThe student pilot's failure to arrest the airplane’s descent rate, which resulted in a hard landing.NTSB WPR20CA087Accident · No injuriesData collectionFinal reportPiper PA28 · Santa Barbara, CAThe pilot's failure to maintain clearance from a parked airplane during taxi operations at night.NTSB WPR20LA062Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · El Monte, CAThe inflight separation of a section of a propeller blade due to a fatigue crack which resulted in a forced landing.NTSB WPR20FA057Accident · 1 fatalClass 3 · FieldFinal reportThunder Mustang TM-1 · Santa Clarita, CAEngine detonation that resulted in material deformation of the crankcase and led to engine failure and restricted cockpit visibility.NTSB WPR20CA060Accident · No injuriesData collectionFinal reportCessna 150 · Twentynine Palms, CAThe pilot's poor preflight planning, during which he failed to verify the proper procedure to activate the runway lights; his inability to locate the airport without lighting; and the airplane’s subsequent low-fuel state as he circled looking for the airport,…NTSB WPR20CA059Accident · No injuriesData collectionFinal reportSud SE 3130 Alouette II · Mokelumne Hills, CAThe pilot's failure to maintain adequate clearance from terrain during a hover-taxi, which resulted in the helicopter's skid contacting grass and a subsequent dynamic roll-over.NTSB WPR20CA069Accident · Serious injuriesData collectionFinal reportGulfstream G IV · Van Nuys, CAThe airplane’s encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.NTSB WPR20CA055Accident · No injuriesData collectionFinal reportCessna 175 · Elk, CAThe pilot's failure to arrest the descent rate during an aborted simulated engine-out approach, which resulted in impact with vegetation and a subsequent cartwheel.NTSB WPR20FA051Accident · No injuriesClass 3 · FieldFinal reportCirrus SF50 · Santa Monica, CAThe improper design of the audio interface system, which caused an electrical short circuit that led to a ground fire.NTSB WPR20CA046Accident · No injuriesData collectionFinal reportBeech 350 · Visalia, CAThe single-engine pilot's failure to yield to traffic established on the taxiway, which resulted in a ground collision.NTSB WPR20CA045Accident · Minor injuriesData collectionFinal reportCessna 140 · Lancaster, CAThe student pilot's failure to maintain directional control and his use of excessive braking while taxiing.NTSB WPR20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Carlsbad, CAThe fatigue failure of the crankshaft. Contributing to the accident was the undocumented installation of the supercharger, which resulted in increased stress on the crankshaft.NTSB DCA20IA034Incident · No injuriesIncident investigationFinal reportAirbus AS 350 B2 · Los Angeles, CAan inflight collision with a hard object of polycarbonate construction, with size and features consistent with that of a small UAS (drone).NTSB WPR20LA035Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH701 · Byron, CAThe pilot/builder's improper construction of the cowling, which resulted in inadequate venting of the engine, its overheating, and a partial loss of engine power.NTSB ANC20FA005Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Blythe, CAA loss of control in flight due to the pilot’s decision to fly into a mountain range, at night, in conditions conducive to high wind, mountain waves, and turbulence.NTSB WPR20CA058Accident · No injuriesData collectionFinal reportAeronca 11AC · San Diego, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind, which resulted in a collision with an airport sign and subsequent ground-loop.NTSB DCA20CA028Accident · No injuriesData collectionFinal reportGeneral Atomics MQ-9 · Palmdale, CAIncorrect control inputs by the student pilot during a crosswind landing, resulting in control saturation and a runway excursion.NTSB WPR20LA026Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Livermore, CAThe improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.NTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.NTSB WPR20FA019Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Upland, CAThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB WPR20FA018Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Brawley, CAThe pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.NTSB WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.