NTSB investigations: Lycoming I0360 series, ND
11 cases on aircraft whose registry engine model is Lycoming I0360 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
| 1967 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1978 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1994 | 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\" = 'ND' 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 ('41515'))
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" = 'ND' 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 ('41515'))
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 CHI94LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDthe pilot-in-command's not maintaining directional control.NTSB CHI91LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe pilot's failure to maintain directional control during the landing roll. Related to the accident was the pilot's lack of total experience.NTSB DEN87LA154Accident · No injuriesLimited investigationFinal reportMooney M20E · Harwood, NDThe plt was landing his Mooney M20E on a private grass airstrip. He said he lowered the manual landing gear and thought he felt the thumblock snap into place. Upon touchdown the landing gear folded up and the acft slid to a stop, resulting in substantial…NTSB DEN83FTG01Accident · 2 fatalFinal reportStolp SA750 · Harwood, NDThe acft impacted the ground in an inverted position in about a 30 degree nose down attitude. The acft was observed doing aerobatics with the last maneuver a spin. The acft spun to an out of sight position behind the trees and a crash was heard. The CFI on…NTSB DEN82DA170Accident · Minor injuriesFinal reportMooney M-20F · Arthur, NDThe pilot landed long and fast. The aircraft collided with an elevated roadbed, shearing off the landing gear.NTSB DEN81FTG19Accident · No injuriesClosedMooney M20J · Mapleton, NDNTSB MKC79FTG02Accident · Serious injuriesClosedBeech C24R · Grand Forks, NDNTSB MKC78FA033Accident · 2 fatalClosedBeech A24R · Mandan, NDNTSB MKC70D0195Accident · No injuriesClosedPiper PA-28R · Bartlett, NDNTSB MKC69D0020Accident · No injuriesClosedMooney M20E · Bottineau, NDNTSB MKC68F0057Accident · No injuriesClosedMooney M20C · Minot, ND