NTSB investigations: Lycoming 0-320 series, NJ
9 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1995 | 1 |
| 1999 | 1 |
| 2002 | 2 |
| 2004 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND 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 c."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC04LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe flight instructor's inadequate preflight inspection, which resulted in an attempted takeoff with contaminated fuel, and a subsequent forced landing.NTSB NYC03LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.NTSB NYC02LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newbolds Corner, NJImproper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.NTSB IAD99LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Fairfield, NJThe flight instructor's failure to maintain rotor rpm and his failure to complete the autorotational descent. A factor in the accident was the flight instructor's failure to fully deploy carburetor heat as directed in the Pilot's Operating Handbook.NTSB NYC95LA179Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Farmingdale, NJthe pilot's improper inflight decision and inaccurate fuel consumption calculations, resulting in a loss of engine power due to fuel exhaustion and a forced landing over unsuitable terrain.NTSB NYC87LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Old Bridge, NJThe plt took off fm the marlboro arpt & flew to 2 other arpts before lndg at the miller arpt at burgettstown, PA, where the eng was shut down. He had difficulty in starting the eng & remained on the gnd about 1 hr. The plt told an aviation safety inspector…NTSB NYC86LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe flight was on approach for landing when engine power was lost due to fuel exhaustion. The aircraft crashed in a tidal marsh and nosed over slightly in the soft marsh and was substantially damaged.NTSB NYC84LA250Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · E. Hanover, NJThe acft made a forced landing shortly after takeoff when the engine lost power. At about 400 ft AGL the engine sputtered and stopped. The fuel tanks were switched by the plt and the engine made a slight pwr gain and quit again. A landing was made in a marshy…NTSB NYC82DA227Accident · Minor injuriesFinal reportPiper PA-22-160 · Marlboro, NJThe aircraft lost power after takeoff. While the pilot was attempted to land, the left wing of the aircraft collided with trees and the plane crashed. The fuel was found to have been exhausted.