NTSB investigations: Lycoming I0360 series, 1970

80 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, newest first

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 year(c.\"eventDate\") = 1970
    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.

NTSB FTW70FQA21Accident · No injuriesClosedPiper PA-28R · Raton, NMMay 18, 1970 · N3894T · Substantial damageNTSB IAD70FIG16Accident · No injuriesClosedMooney M20E · Mitchellville, MDMay 12, 1970 · N1988Y · Substantial damageNTSB OAK70DVM14Accident · No injuriesClosedBeech B95A · Morro Bay, CAMay 10, 1970 · N9399Y · Substantial damageNTSB OAK70FXQ11Accident · No injuriesClosedPiper PA-28R · Bridgeport, CAMay 9, 1970 · N4990J · Substantial damageNTSB OAK70DVG38Accident · No injuriesClosedPiper PA-28R · Weaverville, CAMay 4, 1970 · N9458N · Substantial damageNTSB SEA70DWD14Accident · No injuriesClosedHughes 269B · Hamilton, WAMay 3, 1970 · N9408F · Substantial damageNTSB MKC71DDM18Accident · Minor injuriesClosedHughes 269B · Crosby, MNMay 2, 1970 · N9487F · Substantial damageNTSB OAK70DVM15Accident · No injuriesClosedHughes 269B · San Carlos, CAMay 1, 1970 · N13470 · Substantial damageNTSB MIA70AM088Accident · No injuriesClosedPiper PA-28R · Ashford, ALApr 29, 1970 · N4907J · 2 aircraft · Substantial damageNTSB NYC70DHD17Accident · No injuriesClosedMooney M20C · Berlin, NJApr 26, 1970 · N9721M · Substantial damageNTSB MIA70DLG17Accident · Serious injuriesClosedMooney M20E · Prichardville, SCApr 25, 1970 · N3221F · Substantial damageNTSB LAX70AL067Accident · No injuriesClosedPiper PA-28R · Ramona, CAApr 22, 1970 · N4695J · 2 aircraft · Substantial damageNTSB MIA70FLD19Accident · No injuriesClosedPiper PA-28 · Bradenton, FLApr 9, 1970 · N2911R · Substantial damageNTSB IAD70AI052Accident · 1 fatalClosedPiper J3C-65 · Asheboro, NCMar 22, 1970 · N1112X · DestroyedNTSB LAX70DUG22Accident · No injuriesClosedMooney M20E · Palm Springs, CAMar 21, 1970 · N9215V · Substantial damageNTSB MKC70DDM12Accident · No injuriesClosedMooney M20E · Anoka, MNMar 19, 1970 · N6980U · Substantial damageNTSB FTW70DQG08Accident · No injuriesClosedMooney M20E · Chihuahua, MexicoMar 19, 1970 · N3408X · Substantial damageNTSB CHI70FDJ11Accident · Minor injuriesClosedMooney M20E · Lyndon Stn, WIMar 7, 1970 · N2680W · Substantial damageNTSB MKC70FCD20Accident · No injuriesClosedPiper PA-28R · Crescent, IAMar 1, 1970 · N7665J · Substantial damageNTSB OAK70DVW03Accident · No injuriesClosedBeech BE23 · Mesquite, NVFeb 22, 1970 · N5974S · Substantial damageNTSB LAX70FUG09Accident · No injuriesClosedPiper PA-28R · Big Bear City, CAFeb 18, 1970 · N7471J · DestroyedNTSB SEA70DWD03Accident · No injuriesClosedHughes 269B · Seattle, WAFeb 14, 1970 · N9337F · Substantial damageNTSB LAX70FUG05Accident · No injuriesClosedMooney M20F · Joshua Tree, CAFeb 6, 1970 · N9403V · DestroyedNTSB MKC70AK041Accident · Minor injuriesClosedHughes 269B · Kansas City, MOFeb 5, 1970 · N9512F · 2 aircraft · DestroyedNTSB CHI70FGJ04Accident · No injuriesClosedMooney M20F · Madisonville, KYJan 22, 1970 · N3287F · Substantial damageNTSB CHI70DBD08Accident · No injuriesClosedPiper PA-28R · Hinsdale, ILJan 20, 1970 · N7423J · Substantial damageNTSB CHI70FBG02Accident · No injuriesClosedHughes 269B · Farmington, MIJan 19, 1970 · N9405F · DestroyedNTSB ANC70AA056Accident · No injuriesClosedPiper PA-28R · Juneau, AKJan 18, 1970 · N3867T · Substantial damageNTSB FTW70AF047Accident · 4 fatalClosedPiper PA-28R · Stonewall, TXJan 9, 1970 · N3035R · DestroyedNTSB LAX70FUD01Accident · Minor injuriesClosedMooney M20E · Los Angeles, CAJan 2, 1970 · N9253V · Substantial damage