NTSB investigations, 2004, FL
9 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 22 |
|---|---|
| 1983 | 30 |
| 1984 | 34 |
| 1985 | 31 |
| 1986 | 28 |
| 1987 | 29 |
| 1988 | 34 |
| 1989 | 24 |
| 1990 | 23 |
| 1991 | 13 |
| 1992 | 20 |
| 1993 | 18 |
| 1994 | 15 |
| 1995 | 18 |
| 1996 | 18 |
| 1997 | 19 |
| 1998 | 14 |
| 1999 | 11 |
| 2000 | 6 |
| 2001 | 10 |
| 2002 | 6 |
| 2003 | 15 |
| 2004 | 9 |
| 2005 | 12 |
| 2006 | 9 |
| 2007 | 12 |
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\") = 2004
AND c.\"eventStateOrRegion\" = 'FL' 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") = 2004 AND c."eventStateOrRegion" = 'FL' 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 MIA05CA030Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Panama City Bch, FLThe pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.NTSB MIA05LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pompano Beach, FLThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power in one engine. Contributing factors were the pilot's inadequate handling of the aircraft following failure of the right engine for his failure…NTSB ATL04CA185Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's inadequate preflight inspection and a loss of engine power due to water contamination of the fuel.NTSB MIA04LA126Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Greenville, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply is a contributing factor.NTSB MIA04LA113Accident · Minor injuriesLimited investigationFinal reportRobinson R 22 Mariner · Lantana, FLThe failure of the pilot-in-command to maintain recommended main rotor RPM following a reported total loss of engine power due to undetermined reasons, during a practice autorotation resulting in a hard landing and subsequent roll over.NTSB MIA04LA071Accident · Serious injuriesLimited investigationFinal reportBeech Be-300 · Daytona Beach, FLThe pilot's inadequate management of the airplane's fuel system, which resulted in fuel starvation, a loss of engine power, a forced landing, and damage to the airplane during the landing.NTSB ANC04LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Palm Beach, FLThe incorrect assembly of the fuel selector valve by maintenance personnel, and the pilot's failure to make a precautionary landing to assess the fuel situation and lack of movement of the right fuel tank indicator. which resulted in fuel starvation and the…NTSB ANC04FA042Accident · 2 fatalField investigationFinal reportCessna 150C · DeLand, FLThe pilot's failure to detect water in the fuel system during the preflight inspection, which precipitated a loss of engine power during initial climb, and his failure to maintain adequate airspeed resulting in a stall.NTSB ANC04LA027Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Bradenton, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's failure to maintain adequate rotor speed, resulting in a hard landing.