Final NTSB investigations, ND
67 cases where NTSB found Aircraft oper/perf/capability.
Cases, newest first
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\", '0106'))
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", '0106')) 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 CEN11CA521Accident · No injuriesData collectionFinal reportMills GS-2 · Jamestown, NDThe pilot's loss of directional control during landing in gusty crosswind conditions.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.NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.NTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.NTSB CEN10CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Northwood, NDThe pilot’s failure to maintain adequate clearance from the transmission wire.NTSB CEN10CA333Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL-104 Wilga 80 · Linton, NDThe pilot's failure to maintain aircraft control during landing with a 90-degree crosswind.NTSB CEN10CA191Accident · No injuriesData collectionFinal reportMaule M-5-210C · Bismarck, NDThe pilot’s failure compensate for the crosswinds resulting in a loss of directional control while landing.NTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09CA452Accident · Minor injuriesData collectionFinal reportWeatherly 620B · New England, NDThe loss of engine power for undetermined reasons while maneuvering at low altitude.NTSB CEN09CA404Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare that resulted in a hard landing.NTSB CEN09CA402Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.NTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN09CA219Accident · No injuriesData collectionFinal reportAeronca 7AC-CONV · Stanley, NDThe pilot's failure to maintain directional control during landing.NTSB CHI08CA238Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Buffalo, NDThe pilot's excessive descent rate and his failure to maintain clearance from terrain during the spray run entry.NTSB CHI08CA201Accident · Minor injuriesData collectionFinal reportGrumman G-164D · Esmond, NDThe pilot's delay in advancing the throttle during the takeoff which resulted in inadequate airspeed and the subsequent stall/mush. Factors associated with the accident were the leaking hopper, the pilot continuing to operate the airplane with the known…NTSB CHI08CA142Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's failure to maintained directional control during the aborted landing. Contributing to the accident was the student pilot's total lack of experience in the type of airplane.