NTSB investigations, 2011
4 cases where NTSB found Illness/injury.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 5 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 2 |
| 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\") = 2011
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02012010'))
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", '02012010')) 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 ERA11CA511Accident · Serious injuriesData collectionFinal reportBoeing 737-823 · Miami, FLThe in-flight encounter with clear air turbulence, which resulted in an injury to a cabin attendant.NTSB CEN11LA582Accident · 1 fatalLimited investigationFinal reportVertical Unlimited 12 · Kansas City, MOThe pilot's impairment during an aerobatic airshow performance for reasons that could not be determined based on available information, which resulted in an in-flight loss of airplane control.NTSB ERA11CA322Accident · No injuriesData collectionFinal reportCessna 140A · Quincy, FLThe private pilot's inability to maintain directional control of the airplane during the takeoff roll.NTSB ERA11LA266Accident · Serious injuriesLimited investigationFinal reportAirbus A330-323 · New York, NYThe flight attendant's inadvertent fall, which resulted in a serious injury.