# NTSB investigations: Fairchild SA227-AC: On ground/water collision with object

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 LAX92IA307](https://openairdocs.org/ntsb/LAX92IA307.md): Lockheed L-1011-385-1 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Jul 18, 1992 · N719DA · 2 aircraft · No damage
  > A failure of ground personnel to ensure proper clearance between a taxiing airplane and an adjacent parked airplane. Contributing to the accident was a failure of ground personnel to properly position a parked airplane to ensure that it did not encroach into…
- [NTSB NYC92LA083](https://openairdocs.org/ntsb/NYC92LA083.md): Fairchild SA-227AC · Lexington, KY · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1992 · N27465 · Substantial damage
  > Attempted suicide by the vehicle driver.
- [NTSB DCA91MA018](https://openairdocs.org/ntsb/DCA91MA018.md): Boeing 737-300 · Los Angeles, CA · Accident · 34 fatal · Class 1 · Major · Final report · Feb 2, 1991 · N388US · 2 aircraft · Destroyed
  > The failure of the Los Angeles air traffic facility management to implement procedures that provided redundancy comparable to the requirements contained in the national operational position standards and the failure of the FAA air traffic service to provide…
- [NTSB LAX89FA303](https://openairdocs.org/ntsb/LAX89FA303.md): Fairchild SA227-AC · Los Angeles, CA · Accident · No injuries · Field investigation · Final report · Sep 7, 1989 · N27283 · Substantial damage
  > The fuel truck driver's improper operation of the vechicle on the airport. Factors were the driver's diverted attention and the inadequate supervision by company management.
- [NTSB DEN89FA070](https://openairdocs.org/ntsb/DEN89FA070.md): Swearingen SA-227-AC · Salt Lake City, UT · Accident · No injuries · Field investigation · Final report · Jan 30, 1989 · N169SW · 2 aircraft · Substantial damage
  > The failure of captain of N169SW to maintain a visual lookout while taxiing his aircraft allowing his aircraf to creep into the stationary aircraft in front of him.
- [NTSB LAX89FA086](https://openairdocs.org/ntsb/LAX89FA086.md): Fairchild SA227AC · Los Angeles, CA · Accident · Minor injuries · Field investigation · Final report · Jan 18, 1989 · N26895 · Substantial damage
  > The failure of the fuel tanker driver to see and avoid the moving aircraft. Factors contributing to the accident were the driver's obstructed visibility through the right side of the vehicle's cab, and the dusk light conditions.

## 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 ('3377509')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3377509&occurrence=310

---
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.