NTSB investigations, 2016, CA
14 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 28 |
|---|---|
| 2009 | 41 |
| 2010 | 25 |
| 2011 | 29 |
| 2012 | 23 |
| 2013 | 19 |
| 2014 | 14 |
| 2015 | 17 |
| 2016 | 14 |
| 2017 | 25 |
| 2018 | 11 |
| 2019 | 7 |
| 2020 | 6 |
| 2021 | 8 |
| 2022 | 6 |
| 2023 | 9 |
| 2024 | 9 |
| 2025 | 8 |
| 2026 | 5 |
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\" = '440' 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" = '440' 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 WPR17LA042Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Willows, CAThe decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn…NTSB WPR17LA018Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR17LA011Accident · No injuriesLimited investigationFinal reportMooney M20J · Coalinga, CAA partial loss of engine power due to the pilot's improper in-flight fuel management, which resulted in fuel starvation.NTSB WPR16LA149Accident · No injuriesLimited investigationFinal reportSwartz Gene Titan T 51 Mustang · Lancaster, CAA total loss of engine power due to the separation of a flywheel magnet, which impacted the attachment bracket for the primary and secondary ignition and disrupted the timing of the ignition system, rendering it inoperative.NTSB WPR16LA134Accident · No injuriesLimited investigationFinal reportBell OH 58A · Brawley, CAThe engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…NTSB WPR16LA125Accident · No injuriesLimited investigationFinal reportBell 206 · Bishop, CAThe pilot’s improper preflight weather planning, fuel planning, and fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the severity of the accident was the pilot's initiation of the landing flare at a high altitude,…NTSB GAA16CA303Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Nicolaus, CAThe pilot's insufficient clearance from a power line during aerial application operations, which resulted in a power line strike, a forced landing on unsuitable terrain, loss of directional control, and collision with terrain.NTSB WPR16LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Acampo, CAA total loss of engine power due to a fatigue fracture of the fuel pressure line that connected the fuel control unit and the fuel flow transducer due to vibration as the result of a fatigue fracture of an associated support clamp. Contributing to the…NTSB WPR16FA103Accident · Serious injuriesField investigationFinal reportPiper PA28 · Pomona, CAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR16LA096Accident · No injuriesLimited investigationFinal reportDG Flugzeugbau DG 800B · Clements, CAThe motorglider pilot's decision to perform an in-flight engine start with insufficient altitude, which resulted in an off-airport landing and collision with trees after the engine did not start. Contributing to the accident was the pilot's distraction by the…NTSB WPR16LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Selma, CAThe total loss of engine power due to carburetor icing, which resulted from the flight instructor's failure to use carburetor heat during the descent.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 WPR16LA066Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Santa Barbara, CAA total loss of engine power during initial climbout for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any mechanical anomalies that would have precluded normal operation.NTSB WPR16LA047Accident · No injuriesLimited investigationFinal reportKevin Metzler Velocity STD RG · Rosamond, CAA partial loss of engine power due to failure of the No. 1 connecting rod as a result of multiple fatigue cracks for reasons that could not be determined during on postaccident examination.