NTSB investigations, 1982, ND
3 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 6 |
| 1990 | 3 |
| 1992 | 4 |
| 1994 | 1 |
| 1995 | 4 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 3 |
| 2003 | 1 |
| 2006 | 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\") = 1982
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\" = 250)
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") = 1982 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" = 250) 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 DEN82DA108Accident · No injuriesFinal reportCallair A-9B · Rolla, NDThe pilot reported that after loading with chemical, water, and fuel, he went to a field and began spraying. He stated that after he had made his first swath run, he was turning for a second swath when the plane stalled and crashed. The landing gear,…NTSB DEN82DA050Accident · Serious injuriesFinal reportPiper PA-11 · Devils Lake, NDThe pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted.NTSB DEN82DA047Accident · No injuriesFinal reportTaylorcraft BC-12D · Lisbon, NDThe pilot stated that during the landing on runway 15, at an altitude of approximately 20 to 30 feet, the wind coming over the snowbanks on the sides of the runway caused turbulence that raised the aircraft and pushed it to the left of the runway. The…