NTSB investigations: Lycoming 0-320 series, IN
11 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 | 2 |
|---|---|
| 1983 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 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\" = 'IN' 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" = 'IN' 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 CHI02LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe pilot's improper fuel management resulting in the total loss of engine power due to fuel starvation and the pilot's failure to use the checklist.NTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…NTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.NTSB CHI94LA348Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dale, INthe pilot's failure to assure an adequate fuel supply for the flight. Factors associated with the accident were poor preflight planning, inattentiveness to the fuel supply during the flight, the ditch, and the utility pole which was contacted during the…NTSB CHI93FA161Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paoli, INThe pilot-in-command's inadequate preflight preparations and his failure to maintain airspeed. Factors were the instructor's inadequate training of the pilot-in-command, unqualified maintenance personnel's inadequate inspection of the aircraft and the…NTSB CHI93LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Marysville, INThe pilot's failure to use carburetor heat while flying in carburetor icing conditions.NTSB CHI91DEX02Accident · No injuriesFinal reportHagg Starduster TOO · Shelbyville, INThe pilot's inadequate preflight planning/preparation, not refueling the aircraft before taking off on this flight, and inaccurate fuel consumption calculations. A factor related to the accident is the unsuitable terrain selected by the pilot for a forced…NTSB CHI89LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Indianapolis, INFuel contamination from a deteriorating part in the carburetor. The trees and improper maintenance/servicing of the aircraft were probable contributing factors.NTSB CHI83LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenburg, INThe pilot reported that the engine RPM began dropping while he was crusing at 2500 ft. when carburetor heat was applied, the engine stopped running. The pilot was able to restart the engine and get it to 1200 prm, but it stopped again. A forced landing was…NTSB ATL83LA016Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Indian Mound, INApproximately 10 minutes after departure the pilot of N739RJ reported "engine problems." The pilot stated that he tried various power settings and fuel selections without success. He advised fort campbell approach control that he was landing into trees.…NTSB CHI82FA048Accident · 1 fatalField investigationFinal reportPiper PA-23 · Corydon, INPrior to this flight, the aircraft had not been flown for an extended period. On the day of the accident, it had been sold. The aircraft did not have a current annual inspection and had several maintenance discrepancies. These included problems that prevented…