NTSB investigations, 1983, UT
5 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 4 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 4 |
| 2007 | 3 |
Where
Latest 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\" = '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\" = 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") = 1983 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" = 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 DEN84LA051Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Escalante, UTAbout 15 min after takeoff, the plt reduced the power to aprx 40 to 50% & descended to about 300 ft AGL. When he tried to increase power, the eng faltered. He applied carburetor (carb) heat, but was unable to restore power in time to prevent a forced landing.…NTSB DEN83LA160Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Salt Lake City, UTThe acft landed short of the rwy after a power loss at about 100 ft AGL on final approach. The weather was VMC with the temperature at 80 degrees f and the dewpoint 42 degrees f. the pilot had started a let down at 11,500 ft to descend 5700FT for landing.…NTSB DEN83FA131Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Monticello, UTThe acft crashed while doing magnetometer surveys at low altitude. The right engine had lost power then regained it for a short period and lost it again. A videotape in the acft recorded the plt saying, 'I changed that # just in time.' The acft yawed and the…NTSB DEN83LA109Accident · Minor injuriesLimited investigationFinal reportBeech C-50 · Nephi, UTThe acft collided with rocks and sagebrush during a forced landing after the engine lost power. The acft encountered induction and airframe icing during cruise. The pilots weather briefing forecast the icing which he encountered. The briefing took place about…NTSB LAX83IA174Incident · No injuriesIncident investigationFinal reportDouglas DC-9-82 · 20n Bryce, UTWhile cruising at FL 350 the flt experienced a flame-out of both engines. The crew declared an emergency to salt lake artc center & the flt was vectored toward page,AZ for a possible emergency landing. At 12,200 ft the captain restarted both engines by…