NTSB investigations: Aerostar Acft Corp Of Texas M20F

8 cases on aircraft the registry lists as Aerostar Acft Corp Of Texas M20F. 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

19712026

NTSB investigations: Aerostar Acft Corp Of Texas M20F per year, 1971–2026: 8 cases
1971	2
1973	1
1974	1
1976	1
1989	1
2010	1
2015	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 ('5870314')) 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 ('5870314'))
  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 ('5870314'))
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 WPR16LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar Acft Corp Of Texas M20F · Nogales, AZThe airplane’s impact with a hillside shortly after takeoff for reasons that could not be determined.Dec 26, 2015 · N6811V · Substantial damage NTSB WPR10LA340Accident · No injuriesLimited investigationFinal reportMooney M20F · Cottonwood, AZThe pilot’s failure to lower the landing gear prior to landing.Jul 2, 2010 · N6802V · Substantial damage NTSB FTW89LA149Accident · No injuriesLimited investigationFinal reportMooney M20F · Davis, OKThe pilot's failure to maintian directional control and properly flare the airplane during landing.Aug 15, 1989 · N6814V · Substantial damage NTSB MIA76DLA45Accident · No injuriesClosedMooney M20C · Carrabelle, FLMay 17, 1976 · N6802V · Substantial damage NTSB MIA74FLD73Accident · No injuriesClosedMooney M20F · Lakeland, FLMar 15, 1974 · N6802V · Substantial damage NTSB SEA74AS015Accident · 2 fatalClosedAerostar M20F · St Xavier, MTSep 11, 1973 · N6805V · Destroyed NTSB NYC72FGM01Accident · No injuriesClosedMooney M20F · Warren, PAJul 2, 1971 · N6805V · Substantial damage NTSB NYC71FHJ22Accident · No injuriesClosedMooney M20F · Flushing, NYMar 1, 1971 · N6820V · Substantial damage