NTSB investigations: Lycoming I0360 series, DE
12 cases on aircraft whose registry engine model is Lycoming I0360 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
| 1967 | 1 |
|---|---|
| 1969 | 1 |
| 1975 | 3 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2013 | 2 |
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\" = 'DE' 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 ('41515'))
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" = 'DE' 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 ('41515'))
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 ERA13CA384Accident · No injuriesData collectionFinal reportCessna 172S · Middletown, DEThe student pilot’s improper recovery from a bounced landing.NTSB ERA13LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Dover, DEThe pilot's failure to land the airplane at multiple airports that were equipped with adequate instrument approach procedures while operating in low instrument meteorological conditions and his delay in declaring a fuel-related emergency, which resulted in a…NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.NTSB NYC01FA172Accident · 1 fatalField investigationFinal reportBeech A23-24 · Bridgeville, DEThe pilot's incapacitation, which resulted in a loss of aircraft control while maneuvering. A factor was the FAA Aeromedical Certification Division's inadequate certification/approval of the pilot's medical certificate. Findings were the pilot's inappropriate…NTSB BFO89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dover, DEAfter takeoff the plt began a cruise climb to 5500 ft. he rprtd that when the acft reached 5200 ft, he noticed oil spraying from underneath the front of the eng cowling. The oil eventually covered the windscreen. The plt diverted toward a nearby arpt, but the…NTSB BFO87LA028Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Dover, DEThe rockwell was in level flight at 2800 ft and the Piper was climbing when midair collision occurred. Neither acft was operating under ATC. Neither plt saw the otr acft before the collision occurred. The bottom of the rockwell cabin and the left tiptank of…NTSB NYC84LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Smyrna, DEAcft contacted a ditch and nosed over during a precautionary landing after plt noticed engine was running rough. Cause of engine roughness could not be determined through inspection of the engine.NTSB IAD76DHD10Accident · No injuriesClosedAerocomdr 112 · Rehoboth Beach, DENTSB IAD76AI015Accident · 1 fatalClosedEmstrom F28A · Harrington, DENTSB IAD75II045Incident · No injuriesClosedPiper PA-34 · Dover, DENTSB DIA69D0130Accident · No injuriesClosedPiper PA-28R · Wilmington, DENTSB DIA68D0142Accident · No injuriesClosedBeech A23 · Smyrna, DE