NTSB investigations: Lycoming 0-320 series, GA
14 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 4 |
|---|---|
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 2003 | 1 |
| 2005 | 1 |
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\" = 'GA' 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\" = 353))
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" = 'GA' 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" = 353))
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 ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.NTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.NTSB ATL94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, GAThe pilot's inadequate aircraft pre-flight inspection, his failure to abort the takeoff, and his failure to maintain airspeed that resulted in a stall. A factor was the inadequate aircraft inspection that did not identify the worn fuel cell caps.NTSB ATL93LA010Accident · No injuriesLimited investigationFinal reportCessna 172P · Buford, GAFuel exhaustion due to the pilot's inadequate inflight planning.NTSB ATL90LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lithia Springs, GAImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB ATL87LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Waynesboro, GAThe plt called apch control & asked for vectors to the nearest field & said he was low on fuel. Vectors were provided but the eng lost power & the acft was damaged during a landing in a wooded area. An investigation revealed the acft had been flying for aprx…NTSB ATL85FA179Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Kennesaw, GAPrior to takeoff the plt and his brother-in-law added 20 gallons of automotive fuel to the acft fuel tanks. The level of the fuel, according to the brother-in-law, was below the filler neck tabs. After about three hrs of flt the plt radioed a mayday and…NTSB ATL85FA165Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Milledgeville, GAAcft left home airport at 0400. Flt plan left with FBO indicated 6 hours to destination, no en route stops, and 4+30 hours fuel on board. Fuel consumption calculated, 4+36 hours endurance available. Acft flew 4+47 hours. The pilot told approach control acft…NTSB ATL85LA124Accident · No injuriesLimited investigationFinal reportKirst Allen J DR-1 · Thomaston, GAThe plt made an emergency ldg in a fld after total loss of power due to fuel exhaustion. The plt was on a flt from lakeland, FL. To griffin, GA. With a planned refueling stop at americus, GA. According to the plt he was unable to land at americus due to…NTSB ATL84LA123Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Rome, GAThe acft lost power in the traffic pattern and forced landed off the arpt. The weather was conducive to carburetor icing. The plt said he applied carburetor heat after reducing power.NTSB ATL83FLA01Accident · 2 fatalFinal reportCessna 172M · 9nm Nw Quitman, GAWitnesses observed the acft a little above the tree tops prior to colliding with a high voltage tension wire. The two passengers (ages 10 & 11) were seated in the right front seat, both using the same seat belt. The surviving passenger stated they had…NTSB ATL83LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Albany, GAThe pilot of N737LJ departed on a cross-country business trip with less than full fuel tanks. After flying about 2 hours the aircraft engine quit and the pilot made an emergency landing in an open field. The aircraft collided with trees at the edge of the…NTSB ATL82FKG14Accident · Minor injuriesFinal reportFokker DR-1 · Hampton, GAThe pilot was also the owner of the fixed tri-wing, amateur-built aircraft. After returning from a local flight, he entered the traffic pattern. He flew a large pattern to maintain spacing behind a Cessna 150. After making a low approach, he positioned…NTSB ATL82DA068Accident · No injuriesFinal reportCessna 172N · Chamblee, GAThe engine lost power as the aircraft approached the destination airport. The pilot was unable to start the engine or glide to the airport. While attempting to land on a road, the pilot was able to avoid electrical wires; however, the right wing struck a pole…