NTSB investigations: Lycoming 0-320 series, LA
120 cases on aircraft whose registry engine model is Lycoming 0-320 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, newest first
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\" = 'LA' 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'))
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" = 'LA' 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'))
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 FTW85LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · New Orleans, LAAccording to the CFI there was no intention to perform 'touchdown' autorotation landings. During the third simulated power loss the CFI reported that he initiated the flare at about 55 ft AGL. As airspeed dissipated and the sink rate continued the CFI…NTSB FTW84FA329Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Lake Charles, LAAt aprx 250 ft ag., according to witnesses, eng sounds indicated that power was reduced to idle. The acft rolled into a steep left descending turn followed by the application of power just prior to impact. The CFI was known to have given other students…NTSB FTW84LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Thibodaux, LAThe acft nosed over during a forced landing after the engine quit. A FBO visually inspected the wreckage acft and found little gas and a lack of fuel odor around the acft. Later the engine was refueled and ran normally. The 3 acft fuel tanks were found empty…NTSB FTW83LA321Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Mandeville, LAOn a cross country flight in normal cruise at 2000 ft AGL the engine quit. The pilot made a forced landing to a road. During landing roll the left wing struck a vehicle. The acft then slid into a ditch. Post accident investigation revealed that an oil line…NTSB FTW83LA153Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Athens, LAJust prior to the flt, a mechanic performed some minor upkeep functions on the acft & knew of no mechanical problems. He was unaware that the owner was not a rated plt. The mechanic accompanied the owner on a local flt. Subsequently, the acft crashed on the…NTSB FTW83FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Pineville, LAThe owner, an instructor plt (CFI), was in the right front seat & a private plt with no instrument rating was in the left front seat. During arrival, the aircrew had inquired about the wx at the esler regional arpt, however, the fss & the UNICOM had closed…NTSB FTW83FRD02Accident · 1 fatalFinal reportTeal TSC-1A · Port Sulphur, LAThe eng lost power during a pull-up from a low pass over the arpt. The plt made a forced landing in the icy Mississippi river with the gear down. The amphibian struck a submerged object in the river & flipped over. The plt & pax attempted to swim to shore but…NTSB FTW82DA233Accident · No injuriesFinal reportCessna 172P · Chandeleur Isla, LAWhile on a local photo and sight-seeing flight, the pilot elected to land on Chandeleur island. After landing, he prepared to depart, using the recommended soft field technique. During the takeoff, there was a strong crosswind which caused the aircraft to…NTSB FTW82DA023Accident · 1 fatalClosedPiper PA-28 · Garden City, LANTSB FTW81DRD47Accident · No injuriesClosedGrum Amer AA-5A · Opelousas, LANTSB FTW81DRJ34Accident · No injuriesClosedCallair A-5 · Cottonport, LANTSB FTW81DRJ09Accident · No injuriesClosedPiper PA-28 · Sterlington, LANTSB FTW81DRD11Accident · No injuriesClosedCessna 172M · Belle Chasse, LANTSB FTW81FRD04Accident · No injuriesClosedPitts S-2A · New Orleans, LANTSB FTW81DRD02Accident · No injuriesClosedPiper PA-28 · Lake Charles, LANTSB FTW80FRD44Accident · Minor injuriesClosedSpezio Tu Holer · Hammond, LANTSB FTW80DRD31Accident · No injuriesClosedCessna 172N · Braithwaite, LANTSB FTW79FRD42Accident · No injuriesClosedCessna 172 · Grand Isle, LANTSB FTW79FA060Accident · 4 fatalClosedCessna 172N · Dequincy, LANTSB FTW79DRD18Accident · No injuriesClosedCessna 172M · Franklinton, LANTSB FTW78FRJ33Accident · Serious injuriesClosedPiper PA-18A · Vick, LANTSB FTW78DRD53Accident · Minor injuriesClosedPiper PA-28 · Bogalusa, LANTSB FTW78FRJ25Accident · Minor injuriesClosedPiper PA-18A · Rayville, LANTSB FTW78DRD43Accident · Minor injuriesClosedCessna 172 · Empire, LANTSB FTW78DRD39Accident · No injuriesClosedBeech 23 · Grand Terre, LANTSB FTW78FRD38Accident · No injuriesClosedCessna 172 · Kaplan, LANTSB FTW78DRJ17Accident · No injuriesClosedPiper PA-18 · Ferriday, LANTSB FTW78FRD19Accident · Minor injuriesClosedPiper PA-28 · Jennings, LANTSB FTW78DRD03Accident · No injuriesClosedGrumman AA-5 · Lafayette, LANTSB FTW77FRD53Accident · No injuriesClosedPiper PA-28 · Leonville, LANTSB FTW77DRD27Accident · Minor injuriesClosedPiper PA 28 · Free Mason Is., LANTSB FTW77DRD23Accident · No injuriesClosedCessna 172 · Melville, LANTSB FTW76FRD64Accident · No injuriesClosedCessna 172M · Lake Charles, LANTSB FTW76DRJ28Accident · No injuriesClosedCessna 172 · Many, LANTSB FTW76FRJ27Accident · No injuriesClosedPiper PA-28 · Cotton Valley, LANTSB FTW76FRD44Accident · No injuriesClosedPiper PA-28 · Lafayette, LANTSB FTW76DRJ22Accident · No injuriesClosedCessna 172M · Alexandria, LANTSB FTW76DRJ16Accident · No injuriesClosedPiper PA-22 · Gilliam, LANTSB FTW76FRD09Accident · No injuriesClosedPiper PA-28 · Plaquemine, LANTSB FTW76DRJ09Accident · No injuriesClosedBeech B19 · Holly Ridge, LANTSB FTW7LDRD07Accident · No injuriesClosedPiper PA-18 · Wilson, LANTSB FTW75DRJ24Accident · Minor injuriesClosedPiper PA-28 · Monroe, LANTSB FTW75FRJ17Accident · Minor injuriesClosedPiper PA-23 · Leesville, LANTSB FTW73FRD11Accident · No injuriesClosedPiper PA-28 · New Orleans, LANTSB FTW72AF078Accident · 1 fatalClosedCessna 177 · Many, LANTSB FTW72FRJ04Accident · Serious injuriesClosedPiper PA-28 · Farmerville, LANTSB FTW71FRD37Accident · No injuriesClosedPiper PA-28 · Westwego, LANTSB FTW71FRJ11Accident · Serious injuriesClosedPiper PA-28 · Marthaville, LANTSB FTW71FRJ08Accident · No injuriesClosedPiper PA-18A · Colfax, LANTSB FTW71AF005Accident · No injuriesClosedChampion 7GCAA · Wisner, LA