Final NTSB investigations: Aerospatiale/Aeritalia ATR 42-300
13 cases on aircraft the registry lists as Aerospatiale/Aeritalia ATR 42-300. 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
| 1988 | 2 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680920'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680920'))
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 MIA01LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR 42-300 · Atlantic Ocean (Atlantic Ocean)The in-flight encounter with moderate to severe turbulence in clouds resulting in the serious injury to the flight attendant. A contributing factor in the accident was the poor in-flight planning by the captain for his allowing beverage service to continue…NTSB CHI00IA221Incident · No injuriesIncident investigationFinal reportAerospatiale ATR 42-300 · Champaign, ILThe failure of the aileron trim switch due to foreign material contamination.NTSB CHI99LA289Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe failure of the ramp service clerk to maintain clearance with the operating propeller. A factor related to the accident the inattentiveness on the part of the clerk.NTSB MIA99FA012Accident · Minor injuriesField investigationFinal reportAerospatiale ATR-42-300 · San Juan, PRThe pilot's failure to verify that the parking brake was applied prior to engine start, and the resultant inadvertent movement of the aircraft and collision with the ground power cart once No. 2 was started.NTSB CHI98LA351Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe wake turbulence encountered by Flight 146.NTSB CHI96IA125Incident · No injuriesIncident investigationFinal reportATR 42 · Traverse City, MIimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…NTSB LAX96LA090Accident · Serious injuriesLimited investigationFinal reportATR ATR 42-300 · Honolulu, HIthe flight attendant's decision to leave her seat in an area of forecast and known moderate turbulence. The turbulence was a related factor.NTSB NYC93FA137Accident · No injuriesField investigationFinal reportBoeing 747-368 · Jamaica, NYMissjudged clearance by the captain of the B-747, hz-ais, as he attempted to maneuver around the ATR-42, N242AT. A factor related to the accident was the diverted attention of the captain of the B-747.NTSB CHI93FA129Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe unqualified baggage handler's attempting to load an unfamiliar airplane and inadequate training by the airline which employed the baggage handler.NTSB CHI91MA220Accident · No injuriesMajor investigationFinal reportAerospace ATR-42-300 · Peoria, ILInadequate aircraft equipment component (failed bolt), and insufficient inspection standards pertaining to the failed bolt. A factor related to the accident is inaccurate maintenance record keeping relating to oil consumption.NTSB MIA91IA032Incident · No injuriesIncident investigationFinal reportATR ATR-42-300 · St. ThomasThe failure of the left main landing gear side brace lower arm due to fatigue resulting from corrosion formation, which resulted from improper design to prevent corrosion formation.NTSB CHI89IA034Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Mosinee, WIStall induced by the accretion of moderate to severe clear icing.NTSB CHI88IA045Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Waterloo, IA