Skip to content

NTSB investigations: Lycoming I0360 SER A&C, NJ

12 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 ('41511')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('41511'))
  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 ('41511'))
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 GAA17CA484Accident · No injuriesData collectionFinal reportConstrucciones Aeronauticas C.A.S.A. 1.131 · Ocean City, NJThe pilot’s failure to maintain directional control during the landing roll.Aug 10, 2017 · N211BP · Substantial damage NTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.Feb 17, 2014 · N426SP · Substantial damage NTSB ERA09CA391Accident · No injuriesData collectionFinal reportCessna 172RG · Morristown, NJThe pilot's failure to maintain clearance from a parked aircraft during taxi operations.Jul 4, 2009 · N751DW · Substantial damage NTSB NYC05LA113Accident · Serious injuriesLimited investigationFinal reportMeyer Atlantis · Pittstown, NJThe pilot's failure to maintain clearance from power lines, while returning to the airport after takeoff.Jul 4, 2005 · N98Y · Substantial damage NTSB NYC04LA163Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Hackettstown, NJThe pilot's inadequate preflight inspection, which resulted in the total loss of engine power due to fuel contamination, during the initial climb after takeoff.Jul 11, 2004 · N302SB · Substantial damage NTSB NYC03LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Berlin, NJThe pilot's inadequate preflight inspection which led to an unsecured cowling and loss of aircraft control. Factors were the pilot's diverted attention and the unsecured cowling.Mar 27, 2003 · N8098Q · Substantial damage NTSB NYC01LA191Accident · No injuriesLimited investigationFinal reportMooney M20J · East Greenwich, NJThe pilot's premature liftoff which resulted in an inadvertent stall.Jul 28, 2001 · N246JC · Substantial damage NTSB IAD01LA023Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJthe pilot's failure to maintain proper runway alignment during landing. Factors in the accident were the night lighting and the snow bank.Jan 7, 2001 · N699LP · Substantial damage NTSB NYC99LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-201RT · Toms River, NJThe pilot's failure to obtain proper clearance over an obstacle.Sep 12, 1999 · N8313R · Substantial damage NTSB NYC84FHD04Accident · Serious injuriesFinal reportMooney M20 · Atlantic City, NJThe flt to Atlantic-city-bader field was uneventful, except the acft touched down hard during the landing. The plt taxied to the terminal & parked with the exit door facing the terminal. He elected not to shut down the eng since he intended to immediately…Jun 11, 1984 · N9914S · No damage NTSB NYC83FHA05Accident · Minor injuriesFinal reportDimaria BD-4D · Pittstown, NJPre-takeoff run-up was normal. As the acft lifted off the rwy the eng quit. The acft ran off the rwy onto soft ground & flipped over. The only eng malfunction found was low compression in the #1 cylinder due to both valves being stuck partially open. All fuel…Jul 23, 1983 · N68020 · Substantial damage NTSB NYC82DA213Accident · No injuriesFinal reportMooney M20J · Matawan, NJThe pilot stated that he had never been at this airport before. During arrival, he landed on runway 27 toward the setting sun with a crosswind from the left. He stated that he touched down firmly on the first 1/3 of the runway, then the aircraft floated…Aug 26, 1982 · N1156U · Substantial damage