Skip to content

NTSB investigations · 33

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 ('8632102') 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 ('8632102')
  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 ('8632102')
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 ANC22LA071Accident · No injuriesClass 4 · LimitedFinal reportStinson 10A · Port Alsworth, AKThe pilot's delayed decision to execute a go-around maneuver while landing with a tailwind into a short strip, which resulted in a runway overrun and subsequent loss of control.Sep 3, 2022 · N5847X · Substantial damage NTSB GAA19CA485Accident · No injuriesData collectionFinal reportStinson 10 · Yuba, CAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Jun 17, 2019 · N34658 · Substantial damage NTSB CEN09CA322Accident · No injuriesData collectionFinal reportStinson 10A · Pickwick, MNThe loss of engine power for undetermined reasons.May 17, 2009 · N31584 · Substantial damage NTSB SEA05FA072Accident · 2 fatalField investigationFinal reportStinson 10-A · Oak Harbor, WAThe pilot's failure to adequately plan the approach for landing and maintain clearance from trees during the go-around. A tailwind and trees were factors.Apr 8, 2005 · N39482 · Substantial damage NTSB ANC99LA015Accident · No injuriesLimited investigationFinal reportStinson 10A · Nondalton, AKThe pilot's continued operation of the airplane with known deficiencies, a failure of company maintenance personnel to replace an inoperative fuel gauge, and subsequent fuel exhaustion. Factors in the accident were siphoning of fuel from the right wing fuel…Dec 4, 1998 · N36755 · Substantial damage NTSB ANC85LA153Accident · Serious injuriesLimited investigationFinal reportStinson 10A · Wasilla, AKThe acft contacted trees during a forced landing following a loss of pwr which resulted from fuel exhaustion during an initial takeoff climb. The plt attempted to land on a road, however, when a car pulled onto the road, the plt flew the acft into trees. Only…Aug 18, 1985 · N34656 · Substantial damage NTSB MIA83LA107Accident · No injuriesLimited investigationFinal reportStinson 10A · Miami, FLThe owner of the acft said that the plt was negotiating to buy the acft but conducted this flt without proper authority in the acft that was not airworthy. The plt had landed the acft earlier in an emergency situation declaring a loss of oil pressure and RPM.…Mar 30, 1983 · N39431 · Destroyed NTSB MIA83LA097Accident · No injuriesLimited investigationFinal reportStinson 10A · Defuniak Spring, FLThe engine failed in cruise at 4500 ft MSL. The weather was clear and the pilot could see the airport but did not try for it because of the intervening town. During the landing over wires the landing gear and wings were damaged. The pilotreported that there…Mar 19, 1983 · N32260 · Substantial damage NTSB FTW82DA309Accident · No injuriesFinal reportStinson 10A · Los Lumas, NMWhile landing, the plane touched down in a crosswind from the right at 15 knots. The pilot reported that the plane weathercocked to the right and went into a ditch. Reportedly, the pilot was unable to control the heading of the aircraft in the crosswind.Aug 1, 1982 · N36709 · Substantial damage NTSB SEA80FYM26Accident · No injuriesClosedStinson 10A · Pacific City, ORApr 13, 1980 · N21187 · Substantial damage NTSB NYC78FNC24Accident · No injuriesClosedStinson 10A · Ossipee, NHMay 13, 1978 · N32226 · Substantial damage NTSB LAX77FUK04Accident · Minor injuriesClosedStinson 10A · Tucson, AZSep 19, 1977 · N36748 · Substantial damage NTSB NYC76FNC13Accident · Minor injuriesClosedStinson 10A · Northport, MEAug 21, 1975 · N31586 · Destroyed NTSB IAD75DLJ20Accident · No injuriesClosedStinson 10A · Lumberton, NCFeb 22, 1975 · N36721 · Substantial damage NTSB ANC75FAG56Accident · Minor injuriesClosedStinson 10A · Tyonek, AKNov 16, 1974 · N36755 · Substantial damage NTSB MKC73DCD08Accident · No injuriesClosedStinson 10A · Kiron, IAJul 16, 1972 · N39492 · Substantial damage NTSB MKC72DCD73Accident · Minor injuriesClosedStinson 10A · Troy Mills, IAJun 4, 1972 · N39485 · Substantial damage NTSB CHI72FEV29Accident · No injuriesClosedStinson 10A · Macomb, ILMay 6, 1972 · N27719 · Substantial damage NTSB CHI72FEG15Accident · Serious injuriesClosedStinson 10A · Phillipsburg, OHSep 19, 1971 · N34698 · Destroyed NTSB NYC71FGT13Accident · Minor injuriesClosedStinson 10-A · Hallam, PAApr 9, 1971 · N32203 · Substantial damage NTSB MIA71DKT38Accident · No injuriesClosedStinson 10A · Ft Lauderdale, FLFeb 15, 1971 · N34676 · Substantial damage NTSB NYC70F0188Accident · No injuriesClosedStinson 10A · Washington, PAAug 3, 1969 · N31561 · Substantial damage NTSB FTW70F0047Accident · No injuriesClosedStinson 10A · Mineral Wells, TXMay 30, 1969 · N47302 · Substantial damage NTSB SEA68F0201Accident · No injuriesClosedStinson 10A · Kettle Falls, WANov 4, 1967 · N32298 · Substantial damage NTSB NYC68F0047Accident · Minor injuriesClosedStinson 10A · Shippenville, PAJun 25, 1967 · N36707 · Substantial damage NTSB SEA67D0346Accident · No injuriesClosedStinson 10A · Inehelium, WAMay 31, 1967 · N36765 · Substantial damage NTSB CHI67D0212Accident · No injuriesClosedStinson 10A · Rockton, ILJul 16, 1966 · N32218 · Substantial damage NTSB MIA67F0103Accident · No injuriesClosedStinson 10A · Perry, FLMay 28, 1966 · N32241 · Substantial damage NTSB NYC67D0007Accident · No injuriesClosedStinson 10A · Penn Yan, NYMay 27, 1966 · N32203 · Substantial damage NTSB LAX66D0032Accident · Minor injuriesClosedStinson 10A · Fawn Skin, CAMay 17, 1965 · N36799 · Destroyed NTSB UNK65X0568Accident · No injuriesClosedStinson 10 · Troy, MINov 5, 1964 · N26216 · Substantial damage NTSB UNK64X4161Accident · No injuriesClosedStinson 10A · Pemberton, NJSep 26, 1964 · N36701 · Substantial damage NTSB UNK64X2361Accident · 1 fatalClosedStinson 10A · Mineral, WAJun 18, 1964 · N34692 · Destroyed

Back to Stinson 10A