NTSB investigations, 2016, Outside the U.S.
2 cases where the sequence of events included Landing gear not configured.
Cases per year
| 2010 | 2 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 4 |
| 2020 | 1 |
| 2021 | 7 |
| 2022 | 1 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 2 |
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\") = 2016
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\" = '095' 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") = 2016 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" = '095' 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 ERA16WA342Accident · No injuriesForeign investigationCessna 172RG · Amalfi, ItalyThe government of Italy has notified the NTSB of an accident involving a Cessna Aircraft Company 172RG airplane that occurred on September 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation…NTSB WPR16WA052Accident · No injuriesForeign investigationPiper PA34 · Seletar Airport, Singapore, SingaporeOn January 1, 2016, at 1624 local time, a Piper PA-34, 9M-RBI, operated by a private operator under the pertinent civil regulations of the government of Singapore, was substantially damaged when the airplane landed at the Seletar Airport, Singapore, with the…