NTSB investigations: Smith AEROSTAR 601P, 1986
6 cases on aircraft the registry lists as Smith AEROSTAR 601P. 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 per year
| 1977 | 3 |
|---|---|
| 1978 | 2 |
| 1979 | 3 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 1 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1999 | 4 |
| 2000 | 2 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 2 |
| 2016 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8360608'))
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 year(c."eventDate") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8360608'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ATL87FA030Accident · 4 fatalField investigationFinal reportPiper Aerostar 601P · Clinton, NCWhile en route on an IFR flt plan at FL180, the plt acknowledged instructions to dscnd to 16,000'. Later, the radar controller (cltr) noticed the acft had deviate fm course & was not replying with mode 'c' alt info. The ctlr reqd alt info & the plt responded,…NTSB MIA87LA021Accident · Minor injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Jacksonville, FLWhile in cruise flight, the pilot noted that the left engine began losing power and oil pressure. He stated that he then shut down the engine and feathered the propeller. He declared an emergency and descended to land. While on final approach, he lowered the…NTSB BFO86LA043Accident · No injuriesLimited investigationFinal reportPiper 601P · Indian Head, MDThe owner of the Aerostar 601P was flying his family and a friend from bedford, Massachusetts to Indian Head, Maryland. After monitoring the dca ATIS he elected to make an ILS to fort belvoir, Virginia, break off the missed approach and proceed VFR over to…NTSB NYC86LA193Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Lancaster, PAThe Piper PA-60 Aerostar was making a takeoff with five passengers on board. The PIC did not establish any procedures with his co-pilot prior to the takeoff. The aircraft continued off the 4100 ft runway to the overrun finally becoming airborne. The co-pilot…NTSB MIA86LA145Accident · No injuriesLimited investigationFinal reportPiper 601P · Miami, FLNearing completion of an international flt of nearly 5 hrs duration, the flt advised ATC they were low on fuel & would like vectors to the nearest arpt. The flt was unable to make the arpt & a forced ldg was made in the everglades aprx 6 mi from the arpt. An…NTSB DEN86LA095Accident · Minor injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P Aerostar · Dickinson, NDWhile enroute on an IFR flight plan, the plt changed destination to Dickinson, ND, which extended the length of the flt. He did not desiginate an alternate arpt or have an adequate fuel reserve as required. On arrival at the destination, he executed an…