Fatal NTSB investigations: Lycoming O&VO-360 series, NJ
8 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 per year
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2018 | 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\" = 'NJ' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514'))
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" = 'NJ' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514'))
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 ERA19FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Woodbine, NJThe pilot's failure to maintain the proper airspeed during takeoff, which resulted in the exceedance of the airplane’s critical angle of attack and the airplane experiencing an aerodynamic stall.NTSB NYC05FA140Accident · 1 fatalField investigationFinal reportCessna 177A · S. Hackensack, NJThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and subsequent loss of engine power. A factor in the accident was the pilot's impairment from prescription medication.NTSB DCA00MA080Accident · 11 fatalMajor investigationFinal reportPiper PA-31 Navajo · Burlington Twp., NJthe failure of the pilots of the two airplanes to see and avoid each other and maintain proper airspace separation during visual flight rules flight.NTSB NYC84FA224Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Lincoln Park, NJThe acft collided with the ground shortly after takeoff. A following acft plt said the acft was slow and long on takeoffroll and stayed low after takeoff. The acft made a 90 degree right turn and then a 270 degree left turn and was about lined up to land…NTSB NYC83AA208Accident · 4 fatalFinal reportPiper PA-24-180 · Pomona, NJDuring his wx briefing, the plt was advised of an area of rain showers & scattered thunderstorms along his route of flt, as well as flt precautions for occasional moderate turbulence below 8000 ft which was forcast. He departed norfolk at 1500. At about 1630,…NTSB NYC81FA047Accident · 4 fatalClosedCessna 177B · Forked River, NJNTSB NYC80FA027Accident · 1 fatalClosedMooney M20C · Ogdensburg, NJNTSB NYC79FA027Accident · 1 fatalClosedPiper PA-28 · Newark, NJ