NTSB investigations, 1999, SC
7 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 8 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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\") = 1999
AND c.\"eventStateOrRegion\" = 'SC' 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") = 1999 AND c."eventStateOrRegion" = 'SC' 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 MIA99FA232Accident · 1 fatalField investigationFinal reportBeech C24R · Pickens, SCThe pilot's failure to properly preflight plan and prepare for the flight's fuel consumption resulting in engine loss of power due to fuel exhaustion and the subsequent inflight collision with trees.NTSB MIA99LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greenville, SCThe improper position of the fuel selector by the pilot-in-command resulting in the loss of engine power due to fuel starvation. Also, the inadequate altitude flown by the pilot on final approach preventing a landing on the runway following the loss of engine…NTSB MIA99LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Greenville, SCA total loss of engine power while in descent for landing due to fuel exhaustion as a result of the pilot's failure to properly plan and load the fuel required, and the subsequent collision with the terrain during a forced landing.NTSB MIA99LA174Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Seneca, SCThe PIC's improper fuel management resulting in loss of engine power during approach to landing due to fuel starvation and the subsequent collision with trees and a residence during an emergency landing. Contributing to the accident was the PIC's failure to…NTSB ATL99LA099Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Chapin, SCThe loss of engine power for undetermined reasons. A factor was the collision with a utility wire.NTSB MIA99LA112Accident · No injuriesLimited investigationFinal reportCessna 15OF · Columbia, SCThe pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…NTSB MIA99LA093Accident · No injuriesLimited investigationFinal reportScott A. George Jr. Fisher Celebrity · Simpsonville, SCThe unsuitable terrain encountered during the forced landing. Contributing to the accident was the total loss of engine power due to the failure of a plastic 90-degree fitting at the inlet fitting of the carburetor.