NTSB investigations, 2012
6 cases where NTSB found Monitoring other person.
Cases per year
| 2008 | 27 |
|---|---|
| 2009 | 17 |
| 2010 | 10 |
| 2011 | 7 |
| 2012 | 6 |
| 2013 | 14 |
| 2014 | 14 |
| 2015 | 6 |
| 2016 | 6 |
| 2017 | 6 |
| 2018 | 10 |
| 2019 | 6 |
| 2020 | 8 |
| 2021 | 15 |
| 2022 | 16 |
| 2023 | 11 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 6 |
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\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02021535'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02021535')) 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 WPR13CA068Accident · No injuriesData collectionFinal reportRobinson R22 · Logan, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a failure to maintain adequate main rotor rpm. Contributing to the accident was the wet landing surface.NTSB ANC12CA111Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Anchorage, AKThe flight instructor's inadequate supervision of the student pilot during a hovering autorotation, which resulted in a dynamic rollover.NTSB WPR12CA435Accident · No injuriesData collectionFinal reportPiper PA24 · Madera, CAThe student's and flight instructor’s failure to ensure that the landing gear was extended prior to landing.NTSB CEN12LA648Accident · No injuriesLimited investigationFinal reportHughes 269A · Mc Cool Junction, NEThe flight instructor’s inadequate supervision of the student pilot’s entry into the autorotation, which resulted in a hard landing. Contributing to the accident was the loss of engine power as a result of the student pilot rapidly lowering the helicopter’s…NTSB WPR12LA362Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Spanish Fork, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a hard landing and rollover.NTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…