NTSB investigations, 2016, CA
13 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 8 |
| 2010 | 5 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 13 |
| 2017 | 10 |
| 2018 | 13 |
| 2019 | 10 |
| 2020 | 7 |
| 2022 | 1 |
| 2023 | 5 |
| 2025 | 3 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2016
AND 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\" = '900' 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.
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 year(c."eventDate") = 2016 AND 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" = '900' 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
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 GAA16CA520Accident · No injuriesData collectionFinal reportCessna 182 · Lakeport, CAThe pilot's delayed action to add power during the approach, which resulted in an impact with terrain prior to the approach end of the runway.NTSB GAA16LA525Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Davis, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover. Contributing to the accident was the failure of the seatbelt anchor bracket.NTSB GAA16CA408Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206 · Modesto, CAThe pilot's failure to maintain pitch control during an autorotation, which resulted in abnormal ground contact and main rotor contact with the tail boom. Contributing to the accident was the low fuel level which resulted in fuel starvation and a loss of…NTSB GAA16CA356Accident · Minor injuriesData collectionFinal reportCessna 182 · Llano, CAThe pilot's failure to attain an adequate airspeed and his intentional aerodynamic stall, which resulted in an impact with terrain and a post-impact fire.NTSB WPR16LA132Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · El Centro, CAA loss of main rotor rpm and airframe vibration for reasons that could not be determined based on the available information, which resulted in a forced landing to sloping terrain and the helicopter rolling over.NTSB GAA16CA339Accident · Minor injuriesData collectionFinal reportHughes 269B · Princeton, CAThe uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.NTSB WPR16FA115Accident · No injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Monica, CAA partial loss of engine power during takeoff due to vapor lock. Contributing to the accident was the student pilot's failure to notice that the engine had exceeded multiple temperature limits and that the fuel flow had become erratic during an extended…NTSB WPR16LA105Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Groveland, CAThe pilot's decision to conduct an upslope, downwind takeoff combined with an improper flap setting, which resulted in the airplane's inability to clear trees beyond the runway end. The reason for the improper flap setting could not be determined.NTSB WPR16LA093Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Avalon, CAThe pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…NTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.NTSB WPR16LA075Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Torrance, CAA vibration of the helicopter, which resulted in an autorotation to soft terrain and subsequent impact of the tail boom with the main rotor. The reason for the vibration could not be determined because postaccident examination revealed no malfunctions or…NTSB WPR16LA070Accident · Serious injuriesLimited investigationFinal reportAerostar International RX8 · Petaluma, CAThe pilot's inadequate compensation for wind during the landing approach, which resulted in the balloon’s basket impacting a metal fence and a passenger sustaining serious injuries.NTSB WPR16LA058Accident · No injuriesLimited investigationFinal reportCessna 340A · Bakersfield, CAMaintenance personnel’s repeated failure to re-rig the main landing gear (MLG) in accordance with the airplane manufacturer's service manual requirements, which resulted in the collapse of the right MLG.