NTSB investigations, 2014, CA
16 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 27 |
| 2010 | 28 |
| 2011 | 17 |
| 2012 | 23 |
| 2013 | 23 |
| 2014 | 16 |
| 2015 | 19 |
| 2016 | 22 |
| 2017 | 22 |
| 2018 | 23 |
| 2019 | 21 |
| 2020 | 16 |
| 2021 | 16 |
| 2022 | 16 |
| 2023 | 18 |
| 2024 | 16 |
| 2025 | 20 |
| 2026 | 13 |
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\" = '230' 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" = '230' 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 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 WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing 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 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 WPR14CA328Accident · No injuriesData collectionFinal reportBeech A36 - Undesignat · San Carlos, CAThe pilot's failure to maintain directional control during taxi.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 WPR14CA241Accident · No injuriesData collectionFinal reportCessna 180H · Hesperia, CAThe pilot's failure to maintain directional control during the landing roll.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 WPR14CA200Accident · No injuriesData collectionFinal reportCessna 180 · Cameron Park, CAThe pilot's failure to maintain directional control during landing which resulted in a ground-loop and nose over.NTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.NTSB WPR14CA175Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Monterey, CAThe sport pilot's failure to maintain aircraft control during taxi as a result of improperly manipulating the engine power.NTSB WPR14LA146Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC42 550FG · Truckee, CAThe pilot’s failure to maintain directional control during both the landing and the subsequent attempted go-around.NTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB WPR14CA139Accident · No injuriesData collectionFinal reportBayer Oscar Starduster SA300 · San Luis Obispo, CAThe pilot's inadequate flare, which resulted in a bounced landing and subsequent loss of aircraft control during landing.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.