NTSB investigations: Lycoming 0-320 series, SC

8 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - on ground/water”. 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

19872026

NTSB investigations: Lycoming 0-320 series, SC per year, 1987–2026: 8 cases
1987	1
1989	1
1991	1
1994	1
1997	1
1998	1
1999	1
2001	1

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" = 'SC' 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 ('41508') 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" = 260)) 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\" = 'SC' 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 ('41508')
      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\" = 260))
  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" = 'SC' 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 ('41508')
    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" = 260))
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 MIA01LA161Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennettsville, SCThe pilot's improper correction for wind conditions and his failure to maintain control of the airplane resulting in the airplane sliding off an embankment during taxi from landing.Jun 12, 2001 · N12483 · Substantial damage NTSB MIA99LA090Accident · No injuriesLimited investigationFinal reportCessna 172P · Pelion, SCThe pilot's loss of directional control during landing roll as a result of improper recovery from a bounced landing and the subsequent excursion from the runway, collision with the adjacent terrain, and collapse of the nose landing gear.Feb 21, 1999 · N65770 · Substantial damage NTSB MIA98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCthe pilot-in-command's failure to maintain directional control after landing.Mar 30, 1998 · N2150A · Substantial damage NTSB MIA97LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Pickens, SCfailure of the student pilot to maintain directional control during the takeoff roll from a touch-and-go landing, which resulted in the airplane going off the side of the runway, down an embankment, and into brush/trees.Apr 14, 1997 · N5363W · Substantial damage NTSB ATL95LA026Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe pilot's failure to maintain directional control during a crosswind takeoff.Dec 11, 1994 · N6466D · Substantial damage NTSB ATL92LA011Accident · No injuriesLimited investigationFinal reportWinchester Thorp T-18 · Walterboro, SCThe student pilot's improper use of the wheel brakes, and the subsequent loss of directional control. Factors in this accident were the student pilot's lack of total flying experience and the pilot-in-command's inadequate supervision of the flight.Oct 19, 1991 · N27DW · Substantial damage NTSB ATL89LA156Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Myrtle Beach, SCThe improper installation/modification of the banner tow system, which jammed the rudder during a landing. The wind and terrain conditions were related factors.Jun 2, 1989 · N1652G · Substantial damage NTSB ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…Jan 4, 1987 · N70493 · Destroyed