Skip to content

NTSB investigations: Lycoming I0360 series

2,882 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.

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 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

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.\"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."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

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 NYC65F0015Accident · No injuriesClosedMooney M20E · New Cumberland, PAJan 31, 1965 · N7845V · Substantial damage NTSB LAX65A0063Accident · Minor injuriesClosedHughes 269B · Valley Ctr, CAJan 31, 1965 · N9361F · Substantial damage NTSB CHI65F0024Accident · No injuriesClosedMooney M20E · Louisville, KYJan 12, 1965 · N1937Y · Substantial damage NTSB DEN65A0047Accident · Serious injuriesClosedHughes 269B · Colo Springs, COJan 9, 1965 · N9350F · Destroyed NTSB UNK65X1043Accident · No injuriesClosedHughes 269B · Davis, CADec 18, 1964 · N9374F · Substantial damage NTSB UNK65X0576Accident · No injuriesClosedHughes 269A · Broomfield, CONov 5, 1964 · N8829F · Substantial damage NTSB UNK65X0547Accident · Serious injuriesClosedHughes 269B · Owatonna, MNNov 3, 1964 · N9326F · Destroyed NTSB UNK65X0362Accident · No injuriesClosedMooney M20E · Idaho Falls, IDOct 21, 1964 · N1984Y · Substantial damage NTSB UNK65X0245Accident · No injuriesClosedMooney M21 · Mitchelville, MDOct 11, 1964 · N1233X · Substantial damage NTSB UNK64X4118Accident · Minor injuriesClosedMooney MK21 · Springervill, AZSep 23, 1964 · N6940U · Substantial damage NTSB UNK64X3981Accident · No injuriesClosedMooney M20E · Friendswood, TXSep 14, 1964 · N6845U · Substantial damage NTSB UNK64X3615Accident · No injuriesClosedHughes 269B · Wilson, TXAug 26, 1964 · N9306F · Substantial damage NTSB UNK64X3492Accident · No injuriesClosedMooney M 20E · Fort Worth, TXAug 20, 1964 · N6907U · Substantial damage NTSB UNK64X3436Accident · No injuriesClosedHughes 269B · Redding, CAAug 16, 1964 · N9357F · Substantial damage NTSB UNK64X3371Accident · No injuriesClosedHughes 269A · Fresno, CAAug 13, 1964 · N8863F · Substantial damage NTSB UNK64X3328Accident · No injuriesClosedMooney MK20E · El Paso, TXAug 11, 1964 · N1297X · Substantial damage NTSB UNK64X3324Accident · No injuriesClosedHughes 269B · Las Vegas, NVAug 10, 1964 · N9308F · Substantial damage NTSB UNK64X3081Accident · No injuriesClosedMooney MK21E · Crystal River, FLJul 28, 1964 · N1302W · Substantial damage NTSB UNK64X2982Accident · No injuriesClosedMooney M20E · Chipley, FLJul 23, 1964 · N1938Y · Substantial damage NTSB UNK64X2462Accident · No injuriesClosedMooney MK20E · Hugo, OKJun 24, 1964 · N1987Y · Substantial damage NTSB UNK64X2380Accident · No injuriesClosedHughes 269A · Broomfield, COJun 19, 1964 · N8892F · Substantial damage NTSB UNK64X2198Accident · No injuriesClosedMooney M20E · Richton Park, ILJun 9, 1964 · N1316W · Substantial damage NTSB UNK64X2187Accident · No injuriesClosedMooney M20E · Rockford, ILJun 8, 1964 · N6945U · Substantial damage NTSB UNK64X2037Accident · No injuriesClosedMooney M20E · Pollock, LAMay 30, 1964 · N6969U · Substantial damage NTSB UNK64X1888Accident · 1 fatalClosedHughes 300 · Bishop, CAMay 22, 1964 · N9353F · Destroyed NTSB UNK64X1531Accident · Minor injuriesClosedHughes 269B · West Concord, MNApr 30, 1964 · N9326F · Destroyed NTSB UNK64X1406Accident · Serious injuriesClosedHughes 269B · Winooski, VTApr 21, 1964 · N9323F · Substantial damage NTSB UNK64X1295Accident · No injuriesClosedMooney M20E · Raynesford, MTApr 13, 1964 · N1946Y · Substantial damage NTSB UNK64X0809Accident · No injuriesClosedMooney M20E · Harlingen, TXMar 5, 1964 · N1292X · Substantial damage NTSB UNK64X0684Accident · No injuriesClosedMooney M20A · Covington, GAFeb 24, 1964 · N8390E · Substantial damage NTSB UNK64X0650Accident · No injuriesClosedMooney M21 · Amarillo, TXFeb 22, 1964 · N1333W · Substantial damage NTSB UNK64X0212Accident · 3 fatalClosedMooney M20E · De Beque, COJan 11, 1964 · N1248X · Destroyed