NTSB investigations: Lycoming IO-540 series, NJ
13 cases on aircraft whose registry engine model is Lycoming IO-540 series. 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
| 1980 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 2 |
| 1993 | 1 |
| 1997 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2021 | 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 ('41530', '41585'))
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 ('41530', '41585'))
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 ERA21LA241Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Robbinsville, NJThe pilot’s mismanagement of fuel, which resulted in a total loss of engine power.NTSB ERA20CA252Accident · Minor injuriesClass 4 · Data collectionFinal reportFurlong CA-6 · Manville, NJA loss of directional control on takeoff for undetermined reasons.NTSB GAA16CA314Accident · No injuriesData collectionFinal reportPiper PA 32 · Lincoln Park, NJThe airplane struck a deer during the landing flare resulting in substantial damage.NTSB ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…NTSB ERA10CA479Accident · No injuriesData collectionFinal reportCessna 182S · Toms River, NJThe pilot's failure to maintain an adequate visual lookout during a night taxi. Contributing to the accident was the improper parking of a ground vehicle partially onto the taxiway.NTSB NYC04LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Pittstown, NJThe pilot's failure to obtain a proper climb rate during a go-around, which resulted in a forced landing and subsequent impact with a tree.NTSB NYC97LA072Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Vincentown, NJThe pilot's failure to maintain directional control, which resulted in an on ground loss of control. A contributing factor was a crosswind.NTSB NYC93LA122Accident · 1 fatalLimited investigationFinal reportSmitrvich Starduster SA-300A · Millville, NJThe pilot's inflight planning which resulted in fuel exhaustion. A factor was inadequate preflight planning.NTSB NYC90FA040Accident · 1 fatalField investigationFinal reportPiper PA-60-602P · Frenchtown, NJThe inadequate maintenance and inspection of the turbocharger tailpipe exhaust stack on the right engine by the mechanic(s). The failure of the tailpipe permitted heat from the exhaust to weaken the main spar of the right wing resulting in a catastrophic…NTSB NYC89FA093Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Toms River, NJFailure of the pilot to maintain airspeed and control of the aircraft, and his exceeding the design stress limits of the aircraft. Factors related to the accident were: autoplt malfunction due to improper installation by maintenance personnel and the pilot's…NTSB NYC86FHD03Accident · 1 fatalFinal reportPassonno Skybolt · Moorestown, NJThe Passonno skybolt was observed to recover from a loop and then the tail surfaces started to shake. The acft then descended to the ground and was destroyed by impact. Examination of various horizontal stabilizer and elevator components showed that the…NTSB NYC84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-600 · Newark, NJThe acft was on landing roll when it began to veer from the rwy. The plt attempted to maintain directional control but the acft left the rwy and collided with a taxiway marker sign causing substantial damage to the acft. Shortly thereafter, the right main…NTSB NYC80FHM12Accident · No injuriesClosedPiper PA-32 · Morristown, NJ