NTSB investigations: Lycoming I0360 SER A&C, MD

11 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

19772026

NTSB investigations: Lycoming I0360 SER A&C, MD per year, 1977–2026: 11 cases
1977	1
1988	1
1989	1
2001	1
2006	1
2010	1
2011	2
2017	1
2018	2

Where

Open the map

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" = 'MD' 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\" = 'MD' 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" = 'MD' 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 GAA18CA505Accident · No injuriesData collectionFinal reportCessna 172 · Churchville, MDThe pilot's failure to maintain directional control after landing left of the runway centerline, which resulted in a runway excursion and impact with a power box.Aug 23, 2018 · N419SP · Substantial damage NTSB GAA18CA326Accident · No injuriesData collectionFinal reportCessna 172 · Westminster, MDThe pilot’s improper landing flare, which resulted in a hard landing.May 26, 2018 · N789EP · Substantial damage NTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.Nov 30, 2017 · N474SP · Substantial damage NTSB ERA12LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Frederick, MDThe student pilot’s inadequate directional control during the landing roll.Nov 2, 2011 · N212CF · Substantial damage NTSB ERA11CA408Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe student pilot's improper recovery from a bounced landing.Jul 1, 2011 · N789EP · Substantial damage NTSB ERA10CA305Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, MDThe pilot’s improper flare, which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to land during a thunderstorm.Jun 4, 2010 · N789EP · Substantial damage NTSB NYC06LA055Accident · Serious injuriesLimited investigationFinal reportRenquist Starduster SA300 · Churchville, MDThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall.Jan 20, 2006 · N1923S · Substantial damage NTSB IAD01FA096Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Rohrersville, MDThe pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.Aug 11, 2001 · N2869F · Destroyed NTSB BFO89LA052Accident · Minor injuriesLimited investigationFinal reportMooney M-20F · Mchenry, MDThe pilot landed hard and collapsed the landing gear when he failed to arrest his descent rate during landing. Afterwardas he tried to make a go-around the pilot did not obtain adequate flying speed, the aircraft stalled and collided with the ground.Jul 1, 1989 · N7784M · Substantial damage NTSB BFO89FA003Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Frederick, MDNonsubmittedOct 21, 1988 · N8291Z · Destroyed NTSB IAD77FIG22Accident · No injuriesClosedLake LA4 · Essex, MDJun 30, 1977 · N1236L · Substantial damage