NTSB investigations, 2021, ND
5 cases where NTSB found Personnel issues.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 8 |
| 2010 | 6 |
| 2011 | 10 |
| 2012 | 10 |
| 2013 | 4 |
| 2014 | 6 |
| 2015 | 6 |
| 2016 | 7 |
| 2017 | 3 |
| 2018 | 8 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 9 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 2021
AND c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02'))
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") = 2021 AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02')) 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 CEN22FA017Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-181 · Buxton, NDThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN22LA007Accident · Minor injuriesClass 3 · LimitedFinal reportSoneral L2 · Minot, NDThe pilot’s failure to maintain proper airspeed and exceedance of the airplane’s critical angle of attack on final landing approach, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the pilot’s inexperience with the…NTSB CEN21LA394Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Dunseith, NDThe pilot’s failure to maintain directional control during an attempted go-around with a strong gusting crosswind.NTSB CEN21FA368Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S2R · Strasburg, NDThe pilot’s intentional flight under power lines and his failure to maintain clearance from the lines during an aerial application flight.NTSB CEN21LA337Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Larimore, NDThe pilot’s loss of control during the initial climb for reasons that could not be determined based on the available information.