NTSB investigations, CA
15 cases where the sequence of events included Landing area undershoot.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2022 | 2 |
| 2024 | 2 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '370' 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 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" = '370' 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 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 WPR24LA212Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA31 · Lemoore, CAThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing.NTSB WPR23LA074Accident · Minor injuriesClass 4 · LimitedFinal reportRoyse Ralph L Glasair · Cottonwood, CAThe pilot’s fuel mismanagement which resulted in fuel starvation and a total loss of engine power.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 GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.NTSB GAA17CA367Accident · Minor injuriesData collectionFinal reportCessna 182 · San Martin, CAThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in an impact with a guard rail and post. Contributing to the accident was the pilot’s failure to ensure that sufficient fuel was onboard for nonlevel flight, which…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 WPR16FA029Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350B3E · Carlsbad, CAThe pilot's loss of control during landing on a dolly. Contributing to the accident were the pilot's decision to conduct the flight without an instructor despite multiple flight instructors' recommendations to the contrary, his failure to land on the ramp…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 WPR11CA023Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Fort Hunter Liggett, CAThe pilot's misjudged glide path, which resulted in a runway undershoot and collision with terrain during landing.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.NTSB LAX08LA195Accident · No injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58C · Fresno, CAThe loss of engine power due to fatigue failure of a second stage compressor blade.