NTSB investigations, 2015, FL
4 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2024 | 2 |
| 2026 | 1 |
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\") = 2015
AND c.\"eventStateOrRegion\" = 'FL' 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\" = '120' 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") = 2015 AND c."eventStateOrRegion" = 'FL' 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" = '120' 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 DCA15WA198Incident · No injuriesForeign investigationBoeing 777 · Miami, FLThe National Transportation Safety Board (NTSB) has delegated the investigation of an incident involving a Qatar Airways Boeing 777-300, that occurred on September 15, 2015, to the Civil Aviation Authority (CAA) of Qatar. The NTSB has appointed a U.S.…NTSB ERA15FA299Accident · 1 fatalField investigationFinal reportPiper PA-28R · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation while turning after takeoff in dark night conditions in a sparsely populated area, which resulted in the airplane’s descent into water. Contributing to the…NTSB ERA15FA181Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Fort Lauderdale, FLA rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.NTSB ERA15LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fernandina Beach, FLThe pilot’s physical impairment due to intense pain, which resulted in his failure to maintain airplane control.