NTSB investigations, CA
237 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 36 |
| 2010 | 12 |
| 2011 | 15 |
| 2012 | 20 |
| 2013 | 13 |
| 2014 | 18 |
| 2015 | 14 |
| 2016 | 15 |
| 2017 | 22 |
| 2018 | 16 |
| 2019 | 14 |
| 2020 | 8 |
| 2021 | 4 |
| 2022 | 8 |
| 2023 | 3 |
| 2024 | 4 |
| 2025 | 3 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 WPR26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportHawker Hawker Hunter MK.58 · Big Sur, CAA complete loss of engine power for reasons that could not be determined.NTSB WPR25LA212Accident · 1 fatalClass 4 · LimitedFinal reportCessna T240 · San Diego, CAImpact with the ocean for reasons that could not be determined because the pilot and airplane were not located.NTSB WPR25LA077Incident · No injuriesClass 4 · LimitedFinal reportBombardier Inc., Canadair CL-215-6B11 · Los Angeles, CAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB WPR25FA062Accident · 1 fatalClass 3 · FieldFinal reportAmerican Eurocopter AS350B3 · Potrero, CAThe pilot’s loss of control during cruise flight due to incapacitation for reasons that could not be determined.NTSB WPR25LA048Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20F · Fullerton, CAThe loss of engine power during departure for reasons that could not be determined.NTSB WPR24LA193Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Monument Hills, CAA total loss of engine power for reasons that could not be determined.NTSB WPR24FA073Accident · 4 fatalClass 3 · FieldFinal reportOstroth Thane L Cozy MK IV · Half Moon Bay, CAThe airplane’s impact with the ocean for undetermined reasons after departing into night, instrument meteorological conditions.NTSB WPR24LA030Accident · No injuriesClass 3 · LimitedFinal reportArrow Falcon Exporters UH-1H · Firebaugh, CAAn on-ground fuel fire for reasons that could not be determined due to extensive thermal damage.NTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…NTSB WPR23LA094Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Carlsbad, CAA failure of the No. 2 piston connecting rod bearing due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB WPR23FA007Accident · 1 fatalClass 3 · FieldFinal reportCornford Craig H Mustang II · Jamul, CAImpact with mountainous terrain for undetermined reasons due to the limited evidence that could be collected from the accident sceneNTSB WPR22LA371Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Pacific Ocean, CAUndetermined because the airplane and pilot were not located.NTSB WPR22FA309Accident · 3 fatalClass 3 · FieldFinal reportCessna 152 · Watsonville, CAThe failure of the pilot of the multi-engine airplane to see and avoid the single-engine airplane while performing a straight-in approach for landing.NTSB CEN22FA375Accident · 1 fatalClass 3 · FieldFinal reportSonex Waiex · Maxwell, CAA loss of control in flight for undetermined reasons that resulted in an impact with terrain.NTSB WPR22LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · San Carlos, CAThe total loss of engine power for undetermined reasons.NTSB WPR22LA192Accident · 1 fatalClass 3 · LimitedFinal reportMaule MX-7-180C · Willits, CAAn uncommanded descent during a go-around maneuver for undetermined reasons.NTSB WPR22LA159Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Long Beach, CAThe failure of the right main landing gear brace rib for reasons that could not be determined based on available information.NTSB ANC22LA014Accident · No injuriesClass 3 · LimitedFinal reportBell 205A-1 · El Cajon, CAA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.NTSB WPR21LA366Accident · No injuriesClass 4 · LimitedFinal reportSharp Ralph R Zenith Stol CH 701 · Bishop, CAA loss of airplane control for undetermined reasons.NTSB WPR21LA271Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Riverside, CAA total loss of engine power for reasons that could not be determined from available evidence.NTSB OPS21LA003Incident · No injuriesClass 3 · LimitedFinal reportBoeing 737-8H4 · San Diego, CAThe blocked go-around radio instruction from the air traffic control tower to the arrival aircraft which resulted in the arrival aircraft continuing the landing approach. This led to a loss of separation between the landing aircraft and the aircraft awaiting…NTSB WPR21LA052Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Fallbrook, CAA partial loss of engine power for reasons that could not be determined with the available evidence.NTSB WPR21LA064Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · El Monte, CAA loss of directional control during the landing roll due to an undetermined failure of the tailwheel assembly.NTSB WPR20LA320Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T1A · San Diego, CAA loss of engine power for reasons that could not be determined, which resulted in a hard landing off airport.NTSB WPR20LA288Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chino, CAThe failure of the engine-driven hydraulic pump, which resulted in the main landing gear not fully extending and locking into place during landing. Contributing to the accident was the failure of the emergency gear extension system for reasons that could not…NTSB WPR20LA225Accident · No injuriesClass 3 · LimitedFinal reportVans RV 8 · Grimes, CAA partial loss of engine power for reasons that could not be determined because the airplane was not examined.NTSB WPR20LA175Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Lincoln, CAThe pilot’s loss of directional control on takeoff for undetermined reasons.NTSB WPR20LA136Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Fresno, CAThe partial loss of engine power for reasons that could not be determined based on available evidence.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 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 WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.NTSB WPR20LA009Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 206 · Stockton, CAA total loss of engine power after takeoff for reasons that could not be determined based on the available information.NTSB WPR19LA267Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Modesto, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA201Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · King City, CAA landing gear collapse following an undetermined loss of electrical power, which prevented the landing gear from fully extending.NTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.NTSB WPR19FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172 · Pescadero, CAImpact with the ocean for reasons that could not be determined because the airplane was not located.NTSB WPR19LA155Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Garberville, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA137Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sutter, CAA loss of engine power due to the in-flight separation of the fuel control unit interconnect rod for reasons that could not be determined due to lack of available evidence.NTSB WPR19LA135Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Oxnard, CAThe pilot’s inability to maintain control of the helicopter while maneuvering at a low altitude due to reasons that could not be determined based on available evidence.NTSB GAA19CA282Accident · No injuriesData collectionFinal reportCessna 172 · Edwards Air Force Base, CAAn undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.NTSB WPR19FA118Accident · 1 fatalClass 2 · FieldFinal reportNorthrop N9M · Norco, CAThe pilot's loss of control for undetermined reasons.NTSB WPR19FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech 50 · Riverside, CAThe pilot’s failure to maintain airspeed and control of the airplane following a loss of right engine power for reasons that could not be determined based on the available information.NTSB WPR19LA100Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Watsonville, CAThe pilot’s loss of airplane control during a go-around for reasons that could not be determined based on available evidence.NTSB WPR19LA060Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · San Diego, CALoss of directional control during the landing roll for reasons that could not be determined based on the available information.NTSB WPR19LA039Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Los Banos, CAA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV7A · Ramona, CAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18FA279Accident · 1 fatalClass 2 · FieldFinal reportCessna 177RG · La Verne, CAThe pilot's failure to maintain adequate airspeed and the exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was an undetermined engine…NTSB WPR18LA257Accident · No injuriesClass 2 · LimitedFinal reportPiper J3C · Jackson, CAA loss of directional control during takeoff and initial climb for reasons that could not be determined based on the available information.NTSB WPR18FA219Accident · 1 fatalField investigationFinal reportBeech A36TC · Sylmar, CAThe pilot's failure to maintain airplane control following a total loss of engine power for reasons that could not be determined based on the available information.