Final NTSB investigations, ND
75 cases where NTSB found Task performance.
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\", '0206'))
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", '0206')) 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 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 CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.NTSB CEN11LA593Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Monango, NDThe pilot did not maintain adequate separation from a tree during the aerial-application flight.NTSB CEN11CA570Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Minot, NDThe pilot's failure to maintain directional control during the crosswind landing, resulting in a ground loop.NTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.NTSB CEN11CA521Accident · No injuriesData collectionFinal reportMills GS-2 · Jamestown, NDThe pilot's loss of directional control during landing in gusty crosswind conditions.NTSB CEN11CA477Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Minot, NDThe pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.NTSB CEN11LA397Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDThe student pilot's inadequate recovery from an autorotation and the CFI's delayed remedial action.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 CEN11CA306Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Crosby, NDThe pilot’s failure to maintain directional control of the airplane during the crosswind landing.NTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.NTSB CEN10CA412Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Edmore, NDThe pilot's selection of unsuitable terrain for landing.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 CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.NTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09LA565Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Arvilla, NDThe aircraft owner/mechanic/pilot's installation of an improper tail boom assembly and the resulting fatigue failure of the tail boom's attach fittings.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 CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.NTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…