NTSB investigations, 2003, AR
6 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 7 |
| 1984 | 11 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 6 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
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\" = 'AR' 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" = 'AR' 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 FTW04FA006Accident · Serious injuriesField investigationFinal reportTwin Commander Acft. 680FL · Harrison, ARThe loss of power to both engines due to fuel starvation as a result of the pilot's failure to complete the landing checklist while on final approach. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI03LA323Accident · No injuriesLimited investigationFinal reportCessna 150L · Siloam Springs, ARA loss of engine power due to the pilot's inadequate planning/decision resulting in fuel exhaustion. Factors were the trees and the night conditions.NTSB CHI03LA253Accident · No injuriesLimited investigationFinal reportCessna 140 · Morrilton, ARThe deterioration of the fuel line resulting in fuel contamination and the loss of engine power.NTSB CHI03LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Pine Bluff, ARInadequate preflight planning which resulted in fuel exhaustion during the cross country flight. A factor associated with the accident was the rough terrain encountered during the forced landing.NTSB CHI03LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Smith, ARThe loss of engine power for undetermined reasons during the climb out. A factor was the ditch encountered during the forced landing.NTSB FTW03LA110Accident · No injuriesLimited investigationFinal reportCessna 177A · England, ARThe pilot's failure to refuel the airplane while searching for a private grass airstrip, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.