NTSB investigations, CA

72 cases where the sequence of events included Unknown or undetermined.

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'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 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.May 26, 2019 · N8746S · Substantial damageNTSB GAA19CA284Accident · No injuriesData collectionFinal reportSchweizer 269C · Riverside, CAThe student pilot's failure to maintain yaw control and the engine's rpm during transition to a hover, which resulted in hard landing.May 24, 2019 · N269P · Substantial damageNTSB 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.Apr 28, 2019 · N106ED · Substantial damageNTSB 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.Dec 6, 2018 · N361TC · Substantial damageNTSB WPR18FA075Accident · 1 fatalField investigationFinal reportCessna 152 · Concord, CAA loss of control for reasons that could not be determined based on the available information.Jan 29, 2018 · N93316 · Substantial damageNTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…Oct 21, 2017 · N414MT · DestroyedNTSB WPR17LA197Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Santa Paula, CAA partial loss of engine power during initial climb for reasons that could not be determined based on the available information.Sep 4, 2017 · N75753 · Substantial damageNTSB ANC17FA047Accident · 1 fatalField investigationFinal reportRockwell International S 2R · Calipatria, CAA loss of control for reasons that could not be determined because of the extensive thermal damage from the postcrash fire.Aug 22, 2017 · N5022X · DestroyedNTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…Apr 10, 2017 · N755R · Minor damageNTSB WPR17FA013Accident · 2 fatalField investigationFinal reportBeech A36 · Pittsburg, CAA loss of airplane control for reasons that could not be determined due to the extensive impact and fire damage to the airplane.Oct 25, 2016 · N364RM · DestroyedNTSB WPR16FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Avalon, CAUndetermined because the airplane was not located.May 28, 2016 · N739ZE · DestroyedNTSB WPR15FA174Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Livermore, CAA loss of control for reasons that could not be determined, because examination of the airframe and engine revealed no anomalies that would have precluded normal operation.Jun 2, 2015 · N1348C · DestroyedNTSB WPR15LA168Accident · 1 fatalLimited investigationFinal reportHiller UH 12E · Wasco, CAAn in-flight impact with terrain for reasons that could not be determined based on available evidence.May 27, 2015 · N138HA · Substantial damageNTSB GAA15CA018Accident · No injuriesData collectionFinal reportCessna 172S · Camarillo, CAThe pilot involved and the phase of flight when the damage occurred were not determined.Mar 23, 2015 · N2104H · Substantial damageNTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…Nov 11, 2012 · N700EM · Substantial damageNTSB WPR12LA417Accident · Minor injuriesLimited investigationFinal reportSeymour Skyranger · Perris, CAA loss of aircraft control during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Sep 13, 2012 · N936LS · Substantial damageNTSB WPR12LA411Accident · No injuriesLimited investigationFinal reportCessna A185F · Cambria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane sank in the ocean and was not recovered.Sep 9, 2012 · N80SS · Substantial damageNTSB WPR12FA349Accident · 1 fatalField investigationFinal reportCessna P210N · Santa Monica, CAThe pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…Aug 11, 2012 · N41KA · Substantial damageNTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…Jul 5, 2011 · N9351K · Substantial damageNTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.Mar 20, 2011 · N50MC · Substantial damageNTSB WPR09LA413Accident · Serious injuriesLimited investigationFinal reportAntares US MA-34R · San Jose, CAThe pilot's failure to maintain aircraft control during engine startup, which resulted in a collision with parked aircraft. Contributing to the accident was the engine's inadvertent increase to high power for undetermined reasons.Aug 24, 2009 · N2356W · Substantial damageNTSB WPR09LA149Accident · 1 fatalLimited investigationFinal reportCessna 172N · Oceanside, CAA loss of aircraft control for undetermined reasons.Mar 6, 2009 · N726RJ · Destroyed