NTSB investigations: Lycoming I0360 SER A&C, CA

6 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C, where the first occurrence was “Hard landing”. 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

19842026

NTSB investigations: Lycoming I0360 SER A&C, CA per year, 1984–2026: 6 cases
1984	1
1985	2
2005	1
2006	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" = 'CA' 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') 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" = 200)) 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\" = 'CA' 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')
      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\" = 200))
  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" = 'CA' 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')
    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" = 200))
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 LAX06CA297Accident · No injuriesData collectionFinal reportMooney M20J · Temecula, CAThe pilot's failure to flare that resulted in a hard landing.Sep 17, 2006 · N1157N · Substantial damage NTSB ANC06LA035Accident · Minor injuriesLimited investigationFinal reportClaypool RV-6A · San Diego, CAThe pilot's improper recovery from a bounced landing, which resulted in a hard landing, the collapse of the nose landing gear, and a nose over. A factor associated with the accident was the pilot's failure to perform a go-around.Mar 27, 2006 · N428BC · Substantial damage NTSB LAX05CA275Accident · No injuriesData collectionFinal reportCessna 172S · Edwards AFB, CAthe pilot's misjudged flare and inadequate recovery technique from the subsequent bounces.Jul 20, 2005 · N106ED · Substantial damage NTSB LAX85LA265Accident · No injuriesLimited investigationFinal reportMooney M20J · Rialto, CAAt the conclusion of a nearly 5 hours long non stop flight from NM to CA, the pilot attempted to land at an uncontroll-ed airport. The pilot acknowledged that the aircraft's finalapproach speed was excessive, and after the aircraft toucheddown it bounced off…May 31, 1985 · N3721H · Substantial damage NTSB LAX85IA225Incident · No injuriesIncident investigationFinal reportBeech C24R · Fresno, CAWhile ldg with a left quartering tailwind the student plt bounced the acft. He failed to go around as he had been instructed to do, & after the acft bounced 2 more times its nose gear collapsed. Damage to the acft was minor.Apr 27, 1985 · N6041X · Minor damage NTSB LAX84LA146Accident · No injuriesLimited investigationFinal reportBeech C-24-R · Fullerton, CAA rear seated passg reported that when the acft was about 50 ft AGL he heard the stall warning buzzer sound. Several seconds later acft hit the rwy in a near level attitude. The landing was described by the passgs as 'on the hard side.' Investigation revealed…Jan 15, 1984 · N974V · Substantial damage