NTSB investigations: Commonwealth REARWIN 185

8 cases on aircraft the registry lists as Commonwealth REARWIN 185. 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

19652026

NTSB investigations: Commonwealth REARWIN 185 per year, 1965–2026: 8 cases
1965	1
1967	1
1971	3
1976	1
1987	1
1994	1

Where

Open the map

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 ('2370604')) 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 ('2370604'))
  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 ('2370604'))
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 FTW95LA065Accident · No injuriesLimited investigationFinal reportCommonwealth Rearwin 185 · Longmont, COOil exhaustion and subsequent engine seizure due to a missing oil drain plug. Factors were the inadequate maintenance and the lack of suitable terrain for a forced landing.Dec 12, 1994 · N93290 · Substantial damage NTSB MIA87FA250Accident · 3 fatalField investigationFinal reportCommonwealth 185 · St. Petersburg, FLThe pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…Sep 19, 1987 · N92919 · 2 aircraft · Destroyed NTSB CHI76AC074Accident · 1 fatalClosedCommonwlth 185 · North Liberty, INJun 26, 1976 · N92991 · Substantial damage NTSB NYC72FNE17Accident · No injuriesClosedCommonwlth 185 · Middlebury, CTDec 12, 1971 · N92914 · Substantial damage NTSB LAX72FUG40Accident · No injuriesClosedRearwin 185 · Chino, CADec 10, 1971 · N92902 · Substantial damage NTSB LAX72DUJ45Accident · No injuriesClosedCommonwlth 185 · Mesa, AZSep 20, 1971 · N93290 · Substantial damage NTSB DIA67D0056Accident · No injuriesClosedCommonwlth 185 · Boone, NCMar 12, 1967 · N34130 · Substantial damage NTSB CHI66F0168Accident · Serious injuriesClosedComonwealth 185 · Baraboo, WIAug 13, 1965 · N92834 · Destroyed