NTSB investigations, 2000, NJ
5 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 5 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 8 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 5 |
| 2002 | 3 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 1 |
| 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\") = 2000
AND c.\"eventStateOrRegion\" = 'NJ' 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") = 2000 AND c."eventStateOrRegion" = 'NJ' 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 NYC01LA032Accident · Serious injuriesLimited investigationFinal reportNavion A · Lumberton, NJThe pilot's misjudgment of altitude and distance to the runway while performing a forced landing after an engine failure. Factors related to the accident were the pilot's inadequate rebuilding procedures and maintenance inspection, which resulted in…NTSB NYC01LA026Accident · Serious injuriesLimited investigationFinal reportDever Firefly · Berlin, NJA loss of power for undetermined reasons.NTSB NYC00FA240Accident · Serious injuriesField investigationFinal reportPiper PA-44-180 · Lake Hopatcong, NJThe flight instructor's improper placement of both fuel-selector switches, which resulted in a total loss of engine power on both engines.NTSB IAD00LA052Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Mansfield, NJThe pilot's failure to comply with published emergency procedures. A factor in the accident was the pilot's inadequate preflight planning which resulted in a take-off with the inadequate amount of fuel for the flight.NTSB NYC00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172R · West Milford, NJA loss of engine power for undetermined reasons.