NTSB investigations, 2000, UT
5 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 5 |
| 2002 | 2 |
| 2004 | 4 |
| 2005 | 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\") = 2000
AND c.\"eventStateOrRegion\" = 'UT' 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\" = 351)
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") = 2000 AND c."eventStateOrRegion" = 'UT' 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" = 351) 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 DEN01LA029Accident · No injuriesLimited investigationFinal reportCessna 172E · Salt Lake City, UTthe lack of suitable terrain for a forced landing. A factor was a total power loss due to a connecting rod failure.NTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.NTSB DEN00LA069Accident · Minor injuriesLimited investigationFinal reportHawkins & Powers UH-1B · Helper, UTTotal failure of the number 1 bearing due to lack of lubrication, the oil flow being restricted by a foreign object (epoxy hardener). Factors were trees and the unavailability of suitable terrain for a forced landing.NTSB DEN00LA064Accident · Minor injuriesLimited investigationFinal reportJohnson Zodiac CH 601 HDS · West Jordan, UTTotal failure of an oil line fitting, resulting in oil exhaustion and subsequent engine seizure. Factors were the poor fitting installation by the pilot, and unsuitable terrain on which to make a forced landing.NTSB DEN00LA066Accident · No injuriesLimited investigationFinal reportCessna 310C · Cedar City, UTThe failure of the right engine mixture control cable, which prevented the pilot from restarting the engine. Contributing factors were the pilot's failure to follow procedures by not feathering the right propeller, the rough terrain, and the high vegetation.