NTSB investigations: Airbus Industrie A320-231
7 cases on aircraft the registry lists as Airbus Industrie A320-231. 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
| 1991 | 1 |
|---|---|
| 1998 | 1 |
| 1999 | 3 |
| 2002 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3930325'))
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 ('3930325'))
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 LAX03LA181Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-321 · Payson, AZThe flight's encounter with convectively induced turbulence associated with developing thunderstorms while the flight crew attempted to deviate around an area of adverse weather. The turbulence event occurred while the crew was attempting to maneuver around…NTSB LAX02FA266Accident · Serious injuriesField investigationFinal reportAirbus Industrie A320-231 · Phoenix, AZThe captain's failure to maintain directional control and his inadvertent application of asymmetrical engine thrust while attempting to move the #1 thrust lever out of reverse. A factor in the accident was the crew's inadequate coordination and crew resource…NTSB LAX00LA015Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Phoenix, AZThe airline's failure to fully review the obstruction clearances and revise the pushback procedures in an area of the ramp where new construction had impinged on the available ramp space. Also causal was the failure of the tug driver and the wing walkers to…NTSB LAX99LA323Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Beatty, NVthe failure of the injured passengers to remain seated with their seat belts fastened as directed by the captain.NTSB NYC99IA062Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Columbus, OHa failure of the external o-rings in the nose landing gear steering module.NTSB FTW98LA351Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Denver, COThe failure of the flight crew to comply with braking instructions after being instructed by ground personnel.NTSB LAX91IA415Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Santa Ana, CAThe failure of the flight attendant assigned to the aft galley jumpseat to secure a beverage cart in accordance with company policy.