# NTSB investigations: Fairchild 24R-46A

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CHI98LA322](https://openairdocs.org/ntsb/CHI98LA322.md): Fairchild 24R-46A · Scribner, NE · Accident · No injuries · Limited investigation · Final report · Aug 20, 1998 · N28644 · Substantial damage
  > the inadvertent ground loop caused by an unknown person who was in the process of stealing the airplane.
- [NTSB CHI82DA244](https://openairdocs.org/ntsb/CHI82DA244.md): Fairchild 24R-46A · Franklin, WI · Accident · No injuries · Final report · Jul 11, 1982 · N77697 · Substantial damage
  > The pilot took off and remained in the traffic pattern to land on runway 27. He estimated that the wind was from 300 degrees at 10 knots. He reported that on final approach, he got too low; then about 200 ft short of the runway, his head wind was blocked by…
- [NTSB MKC81FA049](https://openairdocs.org/ntsb/MKC81FA049.md): Fairchild 24R · Waukon, IA · Accident · Serious injuries · Closed · Aug 5, 1981 · N77694 · Destroyed
- [NTSB CHI73FEP67](https://openairdocs.org/ntsb/CHI73FEP67.md): Fairchild F-24 · Portage, WI · Accident · No injuries · Closed · Jun 24, 1973 · N77697 · Substantial damage
- [NTSB NYC70F0065](https://openairdocs.org/ntsb/NYC70F0065.md): Fairchild 24R · Hammondsport, NY · Accident · Serious injuries · Closed · Jun 29, 1969 · N81223 · Destroyed
- [NTSB NYC66F0228](https://openairdocs.org/ntsb/NYC66F0228.md): Fairchild 24R46A · Belmont, NH · Accident · Serious injuries · Closed · Sep 2, 1965 · N81300 · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 ('3370516'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3370516

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
