NTSB investigations, 1985, ND
4 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 5 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 4 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 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 year(c.\"eventDate\") = 1985
AND c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
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\" = 260)
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 year(c."eventDate") = 1985 AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' 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" = 260) 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 DEN85LA191Accident · No injuriesLimited investigationFinal reportCessna 172 · Sykeston, NDThe plt said he made a normal landing on an aerial application airstrip. During the rollout the plt spotted an unmarked mail box. The plt said he swerved to avoid colliding with the mail box. The acft went off the side of the strip and into a field. The plt…NTSB DEN85LA115Accident · No injuriesLimited investigationFinal reportCessna 150M · Beulah, NDThe pilot reported that he encountered turbulence and gusty winds on landing approach to runway 28. He said his speed was fast to compensate for these conditions but that he did not use a crosswind landing technique because the winds had calmed down. The…NTSB DEN85LA101Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Grand Forks, NDOn March 21, 1985, a Piper pa 18 ground looped on landing rollout at gran Forks, ND. The instructor stated the aircraft accident occurred when he was checking out another flight instructor in the tailwheel airplane. During the landing roll out the airplane…NTSB DEN85LA061Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Newburg, NDPlt attempted takeoff on a slippery, snow covered field with a 45 degree x-wind. Acft veered during the takeoff ground run and left main gear sheared off after contacting a snowbank.