Final NTSB investigations, ND
7 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) 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 CHI03LA122Accident · No injuriesLimited investigationFinal reportCessna 182S · Hatton, NDFailure by the flight instructor to maintain clearance to the tree. Contributing factors were the delayed remedial action by the flight instructor and the tree.NTSB CHI02LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot not maintaining clearance from a parked van while taxiing to the parking area. The van was a factor.NTSB CHI01LA188Accident · No injuriesLimited investigationFinal reportAyres S2R-G1 · Mohall, NDthe pilot not maintaining clearance between the airplane and the truck when he backed the airplane off of the loading pad. Factors relating to this accident was the pilot's inadequate visual lookout and the truck.NTSB CHI97LA002Accident · No injuriesLimited investigationFinal reportCessna 185 · Finley, NDfailure of the flight instructor (CFI) to ensure that clearance from the dock was maintained, while starting to taxi. The crosswind was a related factor.NTSB DEN86LA205Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Grandin, NDPlt was attempting to take off from 2600 ft x 50 ft sod strip with full fuel (36 gal) and 160 gal of M22, a fungicide. Center of rwy was soft from recent rains. Plt began takeoff roll on right side of rwy. Right wing and spray boom contacted tall grain stalks…NTSB DEN83LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powers Lake, NDAccording to the plt, he was landing on a road near a friend's house when the left wing hit a steelpost and caused the acft to veer off the road and into a ditch. The acft then nosed over in the ditch.NTSB DEN82DA157Accident · No injuriesFinal reportCessna 172 · Grafton, NDThe pilot stated that when he began to taxi he noticed a Cessna 172 with its engine running in front of a hangar, about 500 feet ahead and to his left. Continuing his taxi, the pilot's attention was diverted by an aircraft on the right. When he looked forward…