NTSB investigations: GE CF34 series, 2000
5 cases on aircraft whose registry engine model is GE CF34 series. 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
| 1993 | 1 |
|---|---|
| 1994 | 1 |
| 1998 | 1 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 8 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 9 |
| 2011 | 8 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 5 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 2000
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('30015'))
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 year(c."eventDate") = 2000
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('30015'))
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 MIA01IA051Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Hebron, KYThe inadequate design of the flight compartment windshield by the windshield manufacturer resulting in cracking of the center ply.NTSB NYC01IA024Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Falmouth, KYThe wake turbulence of another heavy airplane.NTSB ATL00LA092Accident · Serious injuriesLimited investigationFinal reportBombardier CRJ · Atlanta, GAThe inadvertent flight into turbulent weather conditions.NTSB LAX00IA272Incident · No injuriesIncident investigationFinal reportCanadair CL-65 · Monterey, CAFatigue failure of the bell gear in the horizontal stabilizer trim actuator system.NTSB NYC00IA124Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · White Plains, NYThe pilots of the CRJ were conducting a visual approach at night. As the wing flaps were extended from 30 degrees, to 45 degrees, there was an uncommanded extension of the right wing flight spoiler. A roll to the right accompanied the extension, which was…