NTSB investigations: GE CF6-80 series
11 cases on aircraft whose registry engine model is GE CF6-80 series, where the first occurrence was “In flight encounter with weather”. 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 | 1 |
|---|---|
| 1991 | 2 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 2 |
| 2002 | 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 ('30025')
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\" = 240))
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 ('30025')
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" = 240))
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 NYC02LA088Accident · Serious injuriesLimited investigationFinal reportBoeing 767-224 · Atlantic OceanThe airplane's inadvertent encounter which clear air turbulence during cruise flight.NTSB SEA01LA014Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Portland, ORAn inflight encounter with turbulence that occurred before flight attendants could finish stowing a beverage cart and return to their seats.NTSB MIA00LA267Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GAan in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.NTSB FTW98FA380Accident · No injuriesField investigationFinal reportBoeing 767-34AF · Houston, TXThe flight crew's decision to land with convective activity over the airport with a prevailing crosswind to a quartering tailwind, on an ungrooved, flooded runway, which resulted in hydroplaning and a loss of directional control. Factors contributing to the…NTSB NYC97LA187Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 · Long Island, NYAn in-flight encounter with clear air turbulence and the passenger's failure to comply with the fasten seatbelt sign.NTSB NYC97LA040Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean)an encounter with unforecast clear air turbulence and the flight attendant's failure to use the seat belt.NTSB MIA96FA064Accident · Serious injuriesField investigationFinal reportAirbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean)the turbulence and failure of the passengers to have their seat belts fastened. A factor relating to this accident was: the failure of the aircraft operator to advise the flight crew of forecast active intensifying thunderstorm conditions in the area of the…NTSB MIA93LA045Accident · Serious injuriesLimited investigationFinal reportBoeing 767-323ER · Sarasota, FLThe in-flight encounter with weather and the failure of the passengers to comply with the instructions of the flightcrew.NTSB MIA91IA207Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600R · Atlantic Ocean (Atlantic Ocean)The in flight encounter with turbulence, and the failure of the passengers to comply with instructions to return to their seats and utilize their seatbelts.NTSB NYC91LA164Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300-605R · Newark, NJThe inadvertent encounter with in-flight turbulence, resulting in serious injuries to a crewmember and a passenger.NTSB ATL88FA239Accident · Serious injuriesField investigationFinal reportBoeing 767 · Charleston, SC