NTSB investigations, 2003, FL
15 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\") = 2003
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") = 2003 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 ATL04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Kissimmee, FLThe pilot's failure to maintain directional control which resulted in a collision with terrain and obstacles following a loss of right engine power.NTSB MIA04LA022Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Brooksville, FLA loss of engine power due to the pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the helicopter during the landing.NTSB MIA04CA001Accident · Minor injuriesData collectionFinal reportAmerican General AA-1 · Bartow, FLA loss of engine power due to oil starvation. Also causal was the pilot's improper maintenance.NTSB MIA03LA186Accident · Minor injuriesLimited investigationFinal reportS. FL. Ultralights Capella Classic · Port Charlotte, FLThe loss of engine power for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced landing resulting in the airplane cart wheeling and subsequent substantial damage.NTSB MIA03LA184Accident · No injuriesLimited investigationFinal reportCessna 206 · Okeechobee, FLThe total loss of engine power due to fuel exhaustion for undetermined reasons. A finding in the investigation was the inadequate preflight inspection of the airplane by the pilot-in-command for his failure to note a partial blockage at the inlet of the left…NTSB MIA03LA180Accident · No injuriesLimited investigationFinal reportPiper J5A · Winter Haven, FLThe inadequate preflight of the airplane by the pilot-in-command, which failed to detect water-contaminated fuel, and his failure to maintain airspeed resulting in an inadvertent stall.NTSB MIA03TA175Accident · Serious injuriesFinal reportCessna 172P · Jay, FL**This case was modified on 2/18/2016. Refer to the public docket for this accident to view the changes.** Loss of engine power for undetermined reasons.NTSB MIA03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Jupiter, FLThe pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.NTSB MIA03LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Plantation, FLThe pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB MIA03FA135Accident · 2 fatalField investigationFinal reportCessna 414 · N. Fort Myers, FLThe failure of the pilot to maintain airspeed (Vs) following a total loss of engine power from the right engine due to fuel starvation, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees and terrain. Factors in the…NTSB MIA03LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Hammock, FLThe insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…NTSB MIA03LA112Accident · No injuriesLimited investigationFinal reportBeech C23 · Ormond Beach, FLThe pilot's inadequate preflight and his failure to refuel the airplane before departure resulting in the total loss of engine power due to fuel exhaustion and a hard landing during the subsequent forced landing.NTSB MIA03FA054Accident · Serious injuriesField investigationFinal reportCessna 170A · Davie, FLThe pilot's improper preflight planning and his inadequate in-flight planning decision which resulted in loss of engine power due to fuel exhaustion and collision with wires and a road during the subsequent forced landing.NTSB MIA03LA047Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Fort Myers, FLThe pilot's inadequate preflight/preparation and his in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB MIA03TA036Accident · No injuriesFinal reportHughes OH-6 · New Port Richey, FLThe pilot's inadequate preflight of the helicopter following maintenance he observed, and failure of maintenance personnel to tighten the "B" nut at the fuel nozzle following a compressor wash resulting in the total loss of engine power. Also, the pilot's…