Final NTSB investigations, ND
8 cases where NTSB found Performance/control parameters, general.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062000'))
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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062000')) 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 CEN26LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Dickinson, NDThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions which resulted in a hard landing.NTSB CEN21LA044Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-22-135 · Dunn Center, NDThe noninstrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB CEN18LA334Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Kindred, NDThe pilot’s failure to adequately inspect the lower coupling driveshaft during his preflight inspection and his non-compliance with an applicable airworthiness directive, which resulted in the failure of the forward drive splines of the lower coupling…NTSB CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.NTSB CEN16FA212Accident · 3 fatalField investigationFinal reportPiper PA 28-140 · Wishek, NDThe pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…NTSB CEN14CA366Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Cavalier, NDThe pilot's loss of control during the takeoff roll.NTSB CEN12LA336Accident · 1 fatalLimited investigationFinal reportBellanca 8GCBC · Zahl, NDThe non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.NTSB CEN11LA386Accident · No injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.