Skip to content

Interstate S-1A

NTSB investigations · 22

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('1850202') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('1850202')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1850202')
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 WPR26LA286Accident · No injuriesClass 4 · LimitedInvestigation openInterstate S-1A · Blackfoot, IDAug 1, 2026 · N37248 · Substantial damage NTSB WPR22LA003Accident · No injuriesClass 4 · LimitedFinal reportInterstate S-1A · Independence, ORThe separation of the left rudder pedal interconnect cable during takeoff, which resulted in the student pilot’s inability to maintain directional control.Oct 2, 2021 · N37317 · Substantial damage NTSB ERA10LA251Accident · Serious injuriesLimited investigationFinal reportInterstate S1A · Lakeland, FLThe pilot’s failure to maintain clearance from terrain for undetermined reasons.May 1, 2010 · N34926 · Substantial damage NTSB LAX06CA276Accident · No injuriesData collectionFinal reportInterstate S-1A · Buckeye, AZthe in-flight separation of the control stick. A contributing factor was the rough terrain for the forced landing, which resulted in a collapsed landing gear.Aug 1, 2006 · N28332 · Substantial damage NTSB DEN06LA037Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Rocky Ford, COthe pilot's failure to use tie downs before attempting to hand-start the engine. A contributing factor was his failure to seek adequate assistance.Jan 31, 2006 · N28315 · Substantial damage NTSB ANC05LA073Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Palmer, AKThe pilot's misjudged distance and speed, which resulted in an overrun during the landing roll, and subsequent nose over. Factors contributing to the accident were a tailwind and a short landing area.May 7, 2005 · N37209 · Substantial damage NTSB FTW95LA089Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Amarillo, TXAn inflight fire, the reason for which was undetermined.Jan 12, 1995 · N37239 · Destroyed NTSB ANC89LA104Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Iliamna, AKPilot failed to maintain directional control during the attempted go-around. Factors in the accident were the rough/uneven terrain and the brush beside the runway.Jun 27, 1989 · N37209 · Substantial damage NTSB DEN85LTM05Accident · Serious injuriesFinal reportInterstate S-1A · Rock Springs, WYWhile on a x-country flt, the acft encountered turbulence & downdrafts. The plt stated that at 1st, he was not concerned, but then it became apparent that the acft may impact the ground. The acft had limited power (75 HP) & the terrain elevation in that area…Aug 1, 1985 · N37438 · Substantial damage NTSB DEN84LA006Accident · Minor injuriesLimited investigationFinal reportArtic S-1A Cadet · Fullerton, NDThe acft collided with trees during a takeoff from an open OAT field.Oct 11, 1983 · N37286 · Substantial damage NTSB OAK77FVM28Accident · No injuriesClosedInterstate S1A · Monterey, CASep 14, 1977 · N28318 · Substantial damage NTSB MKC76DCQ36Accident · Minor injuriesClosedInterstate S-1A · Spivey, KSFeb 28, 1976 · N37377 · Substantial damage NTSB OAK74FJA05Accident · Minor injuriesClosedInterstate S-1 · No.Pacific Ocean (Pacific Ocean)Oct 21, 1973 · N37328 · Destroyed NTSB SEA72FYC41Accident · Serious injuriesClosedInterstate S-1A · Cascade Lock, ORMay 14, 1972 · N37216 · Destroyed NTSB DEN69A0012Accident · 1 fatalClosedInterstate S-1A · Bitter Creek, WYSep 16, 1968 · N37455 · 2 aircraft · Destroyed NTSB FTW69F0039Accident · Serious injuriesClosedHarlow S-1A · Muenster, TXJul 2, 1968 · N37205 · Substantial damage NTSB DEN67D0237Accident · No injuriesClosedInterstate S-1A · Afton, WYMar 7, 1967 · N37307 · Substantial damage NTSB SEA67F0156Accident · Serious injuriesClosedInterstate S-1A · Pt.Townsend, WAAug 7, 1966 · N37236 · Destroyed NTSB DEN66D0304Accident · No injuriesClosedInterstate S-1A · Fontenelle, WYApr 26, 1966 · N37307 · Substantial damage NTSB SEA66A0009Accident · 1 fatalClosedCallair S-1A · 8sw Billings, MTAug 8, 1965 · N37261 · Substantial damage NTSB DEN65F0041Accident · Serious injuriesClosed2nterstate S-1A · Stanfield, AZMar 16, 1965 · N37292 · Substantial damage NTSB UNK64X3520Accident · No injuriesClosedInterstate S1A · Grace, IDAug 21, 1964 · N37341 · Substantial damage

Back to Interstate S-1A