NTSB investigations, 2010, CA
6 cases where the sequence of events included Preflight or dispatch event.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 3 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2025 | 1 |
Where
Latest 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\") = 2010
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\" = '030' 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") = 2010 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" = '030' 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 WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.NTSB WPR11FA002Accident · Serious injuriesField investigationFinal reportCessna 310 · Avalon, CAThe pilot's improper setting of the left engine fuel selector valve, which resulted in fuel starvation of the left engine immediately after takeoff. Contributing to the accident was the pilot's decision to try to depart ahead of developing weather, which…NTSB WPR10LA408Accident · No injuriesLimited investigationFinal reportBeech V35B · Sacramento, CAA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to ensure that the fuel cap was secured during the preflight inspection.NTSB WPR10CA428Accident · No injuriesData collectionFinal reportHolmgreen John B RV8A · Carlsbad, CAThe pilot’s inadequate pretakeoff checks and failure to maintain control during the takeoff roll. Contributing to the accident was the pilot’s diverted attention due to the open canopy.NTSB WPR10LA200Accident · No injuriesLimited investigationFinal reportBell 222U · Santa Maria, CAThe pilot's inadequate preflight inspection to ensure that all tie-down straps were removed prior to flight. Contributing to the accident was the pilot's improper management of sleep opportunities during the preceding rest period, which likely contributed to…NTSB WPR10CA106Accident · Minor injuriesData collectionFinal reportCessna 140 · Chico, CAThe pilot’s inadequate weather evaluation and failure to maintain clearance from trees while maneuvering in low visibility conditions.