NTSB investigations: Fairchild SA227-AC
6 cases on aircraft the registry lists as Fairchild SA227-AC, where the first occurrence was “On ground/water collision with object”. 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
| 1989 | 3 |
|---|---|
| 1991 | 1 |
| 1992 | 2 |
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 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"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 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" 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 LAX92IA307Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Los Angeles, CAA 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 NYC92LA083Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Lexington, KYAttempted suicide by the vehicle driver.NTSB DCA91MA018Accident · 34 fatalClass 1 · MajorFinal reportBoeing 737-300 · Los Angeles, CAThe 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 LAX89FA303Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Los Angeles, CAThe 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 DEN89FA070Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · Salt Lake City, UTThe 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 LAX89FA086Accident · Minor injuriesField investigationFinal reportFairchild SA227AC · Los Angeles, CAThe 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.