NTSB investigations, SD
5 cases where NTSB found Landing flare.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2019 | 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 c.\"eventStateOrRegion\" = 'SD' AND 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\", '01062041'))
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."eventStateOrRegion" = 'SD' AND 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", '01062041')) 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 GAA19CA487Accident · No injuriesData collectionFinal reportCessna 170 · Bison, SDThe pilot's improper landing flare, which resulted in a hard landing and subsequent ground loop.NTSB CEN17LA265Accident · Minor injuriesLimited investigationFinal reportCubcrafters CC11-160 · Milesville, SDFuel starvation and a subsequent loss of engine power for reasons that could not be determined because a postaccident examination and a test run of the engine did not reveal any anomalies. Contributing to the accident was the pilot’s failure to maintain…NTSB CEN14CA242Accident · No injuriesData collectionFinal reportCessna 170A · Huron, SDThe pilot's inadequate flare resulting in a hard landing.NTSB CEN09LA206Accident · No injuriesLimited investigationFinal reportCessna 402B · Aberdeen, SDThe pilot's continued flight into adverse weather and icing conditions, and his failure to maintain aircraft control resulting in a hard landing. Contributing to the accident was the accumulation of airframe ice and the strong, gusting crosswinds.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.