Fatal NTSB investigations: Columbia Aircraft Mfg LC41-550FG
7 cases on aircraft the registry lists as Columbia Aircraft Mfg LC41-550FG. 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
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2026 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5150011'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5150011'))
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 WPR26FA120Accident · 2 fatalClass 3 · FieldPreliminary reportColumbia Aircraft Mfg LC41-550FG · Albuquerque, NMOn March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from…NTSB ERA18FA251Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 · Woburn, MAThe pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.NTSB CEN17FA071Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Gurdon, ARThe loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.NTSB ERA16FA006Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Erwin, TNThe pilot's decision to fly into a known area of adverse weather, which resulted in the airplane entering a severe thunderstorm and a subsequent loss of control.NTSB ERA14FA292Accident · 1 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · East Patchogue, NYThe noninstrument-rated pilot's encounter with instrument meteorological conditions and his decision to continue visual flight rules flight in instrument conditions, which resulted in a loss of control due to spatial disorientation.NTSB CEN11FA141Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Midlothian, TXThe engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.NTSB ERA09FA377Accident · 2 fatalField investigationFinal reportCessna 400 · Huntington, WVThe pilot's failure to maintain control of the airplane due to spatial disorientation.