NTSB investigations, 1983, 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\") = 1983
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") = 1983 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 DEN84LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe acft veered off the rwy and nosed over in the soft grass during landing. The CFI and student had been practicing crosswind landings on rwy 26 with the wind from 290 degrees at 11 KTS. After the landings the CFI got out of acft so that the student could…NTSB DEN83LA179Accident · No injuriesLimited investigationFinal reportCessna 305A · Minot, NDThe acft swerved off the rwy into a ditch after bouncing during landing. The pilot said he was cleared to land on rwy 13THE winds were from 290 degrees at 4 KTS. The pilot said a gust of wind (none reported) hit the acft during flare for a 2 point landing.…NTSB DEN83LTG02Accident · No injuriesFinal reportAleson Quickie Q2 · Williston, NDThe acft groundlooped and collided with a rwy light following an inadvertant takeoff and landing during what was supposed to be a high speed taxi test. During the landing roll the acft swerved to the left, departed the rwy and collided with a rwy light. This…NTSB DEN83LA130Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cando, NDAfter returning to the arpt, the plt landed on rwy 30 with a right x-wind at about 16, gusting 23 KTS. Reportedly, the grass was aprx 1 ft tall on the rwy & the landing area sloped downward to the west. After touchdown, the plt maintained control of the acft…