NTSB investigations, 2011
6 cases where NTSB found Perception.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 6 |
| 2012 | 3 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 1 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 3 |
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\") = 2011
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02022040'))
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") = 2011 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02022040')) 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 DCA12CA021Accident · No injuriesData collectionFinal reportBoeing 757-351 · Atlanta, GAthe failure of the captain of N303DQ to maintain a safe clearance from N583NW that was stopped on the taxiway.NTSB WPR12CA025Accident · No injuriesData collectionFinal reportCessna 172K · Florence, MTThe pilot's failure to maintain clearance from a power line during a low-level flight along a river. Contributing to the accident was the pilot's decision to fly at a low altitude.NTSB DCA11CA084Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Boston, MAthe B767 Captain's failure to maintain a safe clearance between his wing and the tail of the CRJ900 that was stopped on a taxiway.NTSB WPR11CA249Accident · Minor injuriesData collectionFinal reportRusk Smith Super Cub · Heron, MTThe floatplane's collision with a submerged object during a water landing.NTSB CEN11LA153Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Clarendon, TXThe pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.NTSB WPR11LA094Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Oakley, CAAn in-flight collision with an unmarked meteorological evaluation tower (MET) during an aerial application flight due to the pilot's failure to see and avoid the obstacle. Contributing to the accident was the lack of visual conspicuity of the MET and the lack…