NTSB investigations: Allison AE-3007A
11 cases on aircraft whose registry engine model is Allison AE-3007A. 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
| 2001 | 2 |
|---|---|
| 2007 | 2 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2024 | 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.engine_model_code IN ('03030'))
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.engine_model_code IN ('03030'))
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 DCA24FA179Accident · Minor injuriesClass 2 · FieldFinal reportEmbraer EMB-145LR · Houston, TXThe captain’s unintentional use of the nose down pitch trim during final approach which limited the elevator control authority resulting in a hard landing that collapsed the left main landing gear.NTSB DCA21LA109Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer EMB-145LR · Charlotte, NCan encounter with convective turbulence during descent.NTSB DCA20CA040Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer EMB145 · Philadelphia, PAAn inadvertent encounter with convective turbulence.NTSB DCA14FA058Accident · No injuriesClass 3 · FieldFinal reportEmbraer EMB145 - EP · Memphis, TNthe failure of the flight crew to adequately monitor the system for proper operation and manually activate the system during the flight in icing conditions. Contributing to the accident was the crew's limited training on the manual operation of the anti-ice…NTSB ENG13IA020Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-145 · Houston, TXThe uncommanded left deflection of the airplane's nose wheel due to a malfunction of the electrohydraulic servo valve (EHSV) within the nose wheel steering manifold assembly. The reason for the malfunction could not be determined; however, a foreign substance…NTSB DCA13CA056Accident · Serious injuriesData collectionFinal reportEmbraer EMB-145LR · Hebron, KYan inadvertent fall out of the open service door because the safety strap was not attached.NTSB OPS12IA303Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Farmersville, TXThe flight's continued operation through an area containing substantial convective weather activity. Contributing to the accident was the air traffic control/traffic management unit's lack of awareness and recognition of the effect of weather movement on the…NTSB DCA08IA019Incident · No injuriesIncident investigationFinal reportEmbraer 145 · Jamaica, NYthe failure of the elevator control rods due to exposure to high winds while the aircraft was parked overnight. Contributing to this incident was the failure of the existing airworthiness directive to adequately detect this discrepancy given the known…NTSB DFW07IA077Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dallas, TXThe pilot's failure to maintain directional control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB IAD01LA102Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ-135ER · Richmond, VAInadequate company procedures/directives, which resulted in the flight attendant leaving her seat prematurely, while the airplane was still in an area of turbulence.NTSB NYC01IA107Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Norfolk, VAThe manufacturer's inadequate quality control, which resulted in a jammed elevator trim actuator.