NTSB investigations, Outside the U.S.
3 cases where NTSB found Incorrect action performance.
Cases per year
| 2009 | 2 |
|---|---|
| 2022 | 1 |
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 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\", '02041015'))
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 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", '02041015')) 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 ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.NTSB ERA09FA419Accident · 3 fatalField investigationFinal reportMD Helicopter 530 (369FF) · Camp Butler, IraqThe pilot’s failure to maintain terrain clearance during a low-level course reversal.NTSB ERA09WA335Accident · 1 fatalForeign investigationPiper Aerostar 6 · Minga Guazu, ParaguayOn June 9, 2009, at 1903 local time, a Piper PA-60, N601RP, was destroyed during collision with terrain and a post crash fire on approach to Guarani International Airport (SGES), Minga Guazu, Paraguay. The pilot was fatally injured. Instrument meteorological…