NTSB investigations, 2014, CA
16 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 25 |
| 2010 | 26 |
| 2011 | 15 |
| 2012 | 14 |
| 2013 | 16 |
| 2014 | 16 |
| 2015 | 21 |
| 2016 | 22 |
| 2017 | 28 |
| 2018 | 20 |
| 2019 | 19 |
| 2020 | 7 |
| 2021 | 3 |
| 2022 | 6 |
| 2023 | 7 |
| 2024 | 15 |
| 2025 | 5 |
| 2026 | 9 |
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\") = 2014
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\" = '300' 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") = 2014 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" = '300' 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 WPR15CA066Accident · No injuriesData collectionFinal reportFerdon Thorp T 18 · San Rafael, CAThe pilot's delayed decision to abort the takeoff. Contributing to the accident are an inadequate modification to the seat position, and the pilot's failure to check flight controls for freedom and correct movement.NTSB WPR15LA042Accident · No injuriesLimited investigationFinal reportCessna U206G · La Verne, CAThe pilot's loss of directional control during the landing roll for reasons that could not be determined, because postaccident examination of the nosewheel assembly revealed no anomalies that would have precluded normal operation.NTSB WPR15CA041Accident · No injuriesData collectionFinal reportChampion 7ECA · San Diego, CAThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.NTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.NTSB WPR14CA364Accident · No injuriesData collectionFinal reportFlight Design Ctls LSA · Grass Valley, CAThe pilot's inadequate flare which resulted in a loss of aircraft control during landing.NTSB WPR14CA334Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Bakersfield, CAThe pilot's failure to maintain an adequate approach which resulted in a long landing and runway overrun.NTSB WPR14CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Hoopa, CAThe pilot's inadequate approach and excessive airspeed which resulted in a long landing and subsequent runway overrun onto rough terrain.NTSB WPR14CA268Accident · Minor injuriesData collectionFinal reportCessna L19 - A · Firebaugh, CAThe pilot's inadequate compensation for the wind conditions in the landing area, which resulted in a loss of directional control and encounter with soft terrain and vegetation.NTSB WPR14LA250Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alturas, CAThe airplane’s failure to attain rotation speed during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…NTSB WPR14CA215Accident · No injuriesData collectionFinal reportPiper PA28R - 201T · Novato, CAThe pilot's failure to maintain directional control during landing roll with a crosswind, which resulted in a runway excursion and impact with terrain.NTSB WPR14CA210Accident · No injuriesData collectionFinal reportMeyers OTW 160 · Tehachapi, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with a fence.NTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…NTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.