Skip to content

NTSB investigations: Siai-Marchetti S.205/22R

30 cases on aircraft the registry lists as Siai-Marchetti S.205/22R. 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 per year

19662026

Where

Latest cases

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.aircraft_model_code IN ('8120412')) 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.aircraft_model_code IN ('8120412'))
  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.aircraft_model_code IN ('8120412'))
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 ERA12LA071Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S205-22R · Okeechobee, FLA partial loss of engine power due to a failure of the drive bearings in the alternator drive system. Contributing to the accident was the inadequate maintenance.Nov 5, 2011 · N729WA · Substantial damage NTSB CEN11LA061Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Fruitvale, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Nov 5, 2010 · N971WA · Substantial damage NTSB ERA11FA021Accident · 1 fatalField investigationFinal reportSiai-Marchetti S.205/22R · Farmingdale, NYA loss of engine power during a low approach for undetermined reasons.Oct 17, 2010 · N934W · Substantial damage NTSB LAX06LA109Accident · Minor injuriesLimited investigationFinal reportSIAI-Marchetti S.205/22R · Phoenix, AZa loss of engine power for undetermined reasons.Feb 12, 2006 · N981WA · Substantial damage NTSB FTW00LA096Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Rayville, LAThe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the dark night light condition.Mar 14, 2000 · N2832W · Substantial damage NTSB CHI96LA132Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Anoka, MNA loose exhaust system that had become disconnected and blocked, which resulted in partial loss of engine power.Apr 13, 1996 · N954W · Substantial damage NTSB LAX88LA292Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Bullhead City, AZAt the end of a cross country flight, the pilot had to abort the landing the first time due to heavy rain showers and turbulence. The pilot returned for landing and during the landing roll on the wet runway, the pilot lost control of the airplane. The…Aug 21, 1988 · N955W · Substantial damage NTSB CHI82DA280Accident · Minor injuriesFinal reportSIAI Marchetti S.205-22/R · Carrollton, ILThe aircraft engine failed inflight and during the forced landing on a road the aircraft collided with posts. An investigation showed that a #4 connecting rodcap attaching bolt had failed.Jul 29, 1982 · N956W · Substantial damage NTSB IAD76FKM29Accident · Serious injuriesClosedSiai-Marche S20522 · Greensboro, NCFeb 29, 1976 · N996WA · Substantial damage NTSB FTW76FRG35Accident · No injuriesClosedSiai-Marche S.205 · Austin, TXJan 13, 1976 · N733W · Substantial damage NTSB MIA76FLD38Accident · No injuriesClosedSiai-Marche S.205 · Venice, FLJan 12, 1976 · N974W · Substantial damage NTSB NYC75FGM28Accident · No injuriesClosedSiai-Marche S205 · Drifting, PAMar 27, 1975 · N985WA · Substantial damage NTSB FTW74DRG52Accident · No injuriesClosedSiai-Marche S.205 · Cotulla, TXJan 17, 1974 · N984WA · Substantial damage NTSB NYC74FFJ11Accident · Minor injuriesClosedSIAI Marche 205-22 · Niagara Falls, NYSep 30, 1973 · N952W · Substantial damage NTSB IAD74FLQ04Accident · No injuriesClosedSiai-Marche S.205 · Bardstown, KYAug 19, 1973 · N986WA · Substantial damage NTSB CHI73FEC38Accident · No injuriesClosedSiai-Marche 22R · Lambertville, MIMay 25, 1973 · N2833W · Substantial damage NTSB CHI73FEP06Incident · No injuriesClosedSiai-Marche 20522R · Juneau, WIJul 22, 1972 · N732W · Minor damage NTSB NYC72FHD32Accident · No injuriesClosedSiai-Marche S20522 · Atlantic City, NJApr 1, 1972 · N736W · Substantial damage NTSB CHI72FEM44Accident · No injuriesClosedSiai-Marche 205-22 · Eagle, MIJan 21, 1972 · N4780G · Substantial damage NTSB MIA72AM061Accident · 3 fatalClosedSiai-Marche S205 · Carters, GADec 28, 1971 · N995WA · Destroyed NTSB MIA72DKT15Accident · No injuriesClosedSiai-Marche S.205 · W Palm Beach, FLSep 5, 1971 · N993WA · Substantial damage NTSB CHI72DEE25Accident · No injuriesClosedSiai-Marche S205 · Northbrook, ILAug 30, 1971 · N2832W · Substantial damage NTSB MIA71FKW47Accident · No injuriesClosedWaco S 20522R · Chattanooga, TNApr 18, 1971 · N987WA · Substantial damage NTSB CHI71FCG27Accident · Minor injuriesClosedSiai-Marche S205 · N.Lewisburg, OHMar 11, 1971 · N950W · Substantial damage NTSB LAX71FUA38Accident · No injuriesClosedSiai-Marche 20522R · Hntngtn Bch, CADec 16, 1970 · N992WA · Substantial damage NTSB LAX71DVA47Accident · No injuriesClosedSiai-Marche S-205 · Bakersfield, CADec 5, 1970 · N970WA · Substantial damage NTSB LAX70D0059Accident · No injuriesClosedSiai-Marche S.205 · Searchlight, NVJul 18, 1969 · N973WA · Substantial damage NTSB MIA69A0034Accident · 4 fatalClosedSiai-Marche 205-22 · Tifton, GADec 27, 1968 · N997WA · Destroyed NTSB LAX69F0076Accident · No injuriesClosedSiai-Marche S205 · Santee, CAAug 8, 1968 · N970WA · Substantial damage NTSB LAX67F0216Accident · No injuriesClosedSIAI March. S-205 · Phoenix, AZDec 1, 1966 · N4780G · Substantial damage