Final NTSB investigations, ND
8 cases where NTSB found Delayed action.
Cases per year
| 2008 | 1 |
|---|---|
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 2 |
| 2022 | 1 |
| 2024 | 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\" = '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\", '02041025'))
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", '02041025')) 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 CEN24LA343Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Grand Forks, NDThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground. Contributing to the outcome was the flight instructor’s delayed remedial action.NTSB CEN22LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fargo, NDThe flight instructor’s failure to adequately monitor the pilot flying, which resulted in a nose-wheel first hard landing.NTSB CEN14CA513Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a tail rotor strike.NTSB CEN14CA410Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Beach, NDThe student pilot's failure to initiate a go-around sooner, and his failure to maintain directional control.NTSB CEN12CA426Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate landing flare, which resulted in a hard landing.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 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…