NTSB investigations, 2018, NE
4 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 1 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 4 |
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\") = 2018
AND c.\"eventStateOrRegion\" = 'NE' 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\" = '240' 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") = 2018 AND c."eventStateOrRegion" = 'NE' 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" = '240' 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 CEN18LA314Accident · Serious injuriesLimited investigationFinal reportAirbus EC 130 T2 · Mullen, NEThe pilot’s inadequate and incorrect antitorque pedal application during a tight, decelerating turn downwind, which resulted in a loss of yaw control.NTSB GAA18CA408Accident · No injuriesData collectionFinal reportRobinson R44 · Rulo, NEThe pilot's improper collective application, which resulted in low rotor rpm during the takeoff climb and a subsequent ground collision. Contributing to the accident was the pilot’s self-induced pressure to complete the operation.NTSB CEN18FA242Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Arthur, NEThe pilot's failure to recover from a spin for reasons that could not be determined based on the available information.NTSB CEN18FA126Accident · 1 fatalField investigationFinal reportRans S-16 Shekari · Pierce, NEThe pilot's failure to maintain airspeed during the approach for landing, which resulted in an aerodynamic stall and the airplane's impact with terrain.