NTSB investigations: Lycoming 0-540 series, 1985

59 cases on aircraft whose registry engine model is Lycoming 0-540 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 year(c."eventDate") = 1985 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')) 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 year(c.\"eventDate\") = 1985
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
  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 year(c."eventDate") = 1985
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
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 MIA85FA112Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Jacksonvile, FLThe single eng land, pvt plt had an instrument rating, but had no rating to fly multi-eng acft. While on an illegal flt with marijuana on board, he contacted jacksonville apch control & advised that he could not see the ground due to dense ground fog, the…Mar 4, 1985 · N100DT · Destroyed NTSB ATL85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Reidsville, GAThe acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…Feb 28, 1985 · N4565P · Destroyed NTSB CHI85LA122Accident · No injuriesLimited investigationFinal reportCessna 182RG · Mundelein, ILThe plt of this acft did not know the rwy surface condition prior to an attmpted landing. UNICOM advisories were not available. Due to a recent storm, six to twelve inches of wet snow overlying a patchy layer of compacted snow existed when he touched down.…Feb 17, 1985 · N736ZX · Substantial damage NTSB ATL85LA100Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Hilton Head, SCAcft stalled & crashed from an altitude of about 300 ft. witnesses stated that the acft entered a steep clumb angle upon lift off and climbed to about 300 ft. then the acft nosed over & fell to the ground.Feb 17, 1985 · N5636B · Substantial damage NTSB MIA85LA094Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ft.Lauderdale, FLThe acft landed with a x-wind component of about 25 KTS from the right. The plt and witnesses stated the wind lifted the right wing of off the rwy. Side forces resulted in the left main landing gear collapsing. Maximum demonstrated takeoff and landing x-wind…Feb 11, 1985 · N9207E · Substantial damage NTSB LAX85FA137Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Corona, CAAfter refueling, the acft took off & lost pwr at 150 ft to 200 ft AGL. The acft struck trees while in a steepening left bank & crashed in an open field adjacent to the arpt. No contaminants or water were found either in the acft's fuel system or in the fuel…Feb 9, 1985 · N8898 · Destroyed NTSB MIA85FA089Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Key Largo, FLThe aircraft crashed into the waters of the atlantic ocean and sank nose first into 15 feet of water. On impact the 25 bales of marijuana located in the cabin of the aircraft shifted forward and pinned the pilot and passenger in the aircraft. No usable fuel…Feb 3, 1985 · N5103Y · Substantial damage NTSB FTW85LA099Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Addison, TXThe plt stated that on touchdown, the acft veered left & went off the edge of the 30' wide rwy. The nose gear then collapsed in soft terrain before the plt could get the acft back on the rwy surface. At 1900 CST, the wind was from 360 deg at 30 gusting 40 KTS.Jan 20, 1985 · N96DD · Substantial damage NTSB ATL85FA077Accident · 4 fatalField investigationFinal reportCessna R182 · Crossville, TNThe acft collided with wooded, rising terrain at an elevation of about 2800 ft MSL on the west slope of hinch mountain. A passenger, who survived the crash, but died later due to burns, reported that light conditions were dark & she could not see anything…Jan 7, 1985 · N4716R · Destroyed