NTSB investigations, CA
8 cases where the defining event was Landing area undershoot.
Cases per year
| 2009 | 2 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2022 | 1 |
| 2024 | 1 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '370')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '370') 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 WPR25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201T · Placerville, CAThe pilot’s failure to maintain an adequate descent rate during the landing approach, which resulted in an impact with terrain short of the runway threshold.NTSB WPR22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Oceanside, CAThe right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.NTSB GAA17CA171Accident · Minor injuriesData collectionFinal reportSmith Douglas J. Sonex · Mercey Hot Springs, CAThe sport pilot’s unstabilized approach with a tailwind, which resulted in touchdown short of the runway and a subsequent nose-over.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 WPR12LA126Accident · No injuriesLimited investigationFinal reportQuicksilver MX Sprint II · Willits, CAThe student pilot did not maintain an adequate approach/glide path and altitude, which resulted in a runway undershoot and subsequent collision with trees. Contributing to the accident was the student pilot's lack of flight experience.NTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.NTSB WPR10CA020Accident · Minor injuriesData collectionFinal reportMooney M20J · Hesperia, CAThe pilot's improper glide path and failure to maintain clearance from the airport perimeter fence during the landing approach.NTSB WPR09CA148Accident · No injuriesData collectionFinal reportEurocopter AS350BA · Long Beach, CAThe pilot's misjudged speed and altitude, which resulted in an undershoot of the landing zone.