NTSB investigations, 1982, ND
4 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 3 |
| 1996 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 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\") = 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\" = 353)
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" = 353) 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 DEN82DA139Accident · No injuriesFinal reportSikorsky S-55B · Wahpeton, NDAfter receiving his last load of chemical, the pilot thought he had enough fuel to complete two spray passes to finish the field before proceeding to the fuel truck. He completed the passes, then pulled to about 150 ft AGL to fly about three miles to refuel.…NTSB DEN82DA140Accident · Minor injuriesFinal reportPiper PA-22 · Glenburn, NDThe pilot reported that the engine lost power at about 100 AGL during a night takeoff. The aircraft was examined after the crash and the fuel selector was found positioned on the right tank. The aircraft had remained upright during and after the crash and the…NTSB DEN82DA136Accident · No injuriesFinal reportCessna T188C · Starkweather, NDThe pilot reported that the aircraft fuel tank had run out of fuel, so he added 2 to 3 gallons of av-gas. He said he thought this would be enough fuel to ferry the the aircraft four miles. He took off, and upon reaching about 400 ft AGL, the engine lost…NTSB DEN82DA133Accident · No injuriesFinal reportPiper PA-25D-260 · Edgeley, NDThe aircraft lost power on takeoff and a forced landing was made in an open field. The aircraft had been refueled from barrels by the pilot. His fuel contained water from recent rain. During an examination of the aircraft, water was found in the fuel pump;…