Skip to content

NTSB investigations: Lancair LC41-550FG

12 cases on aircraft the registry lists as Lancair 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20032026

Where

Latest cases

Query with SQL

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 ('5150001')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('5150001'))
  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 ('5150001'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN20WA142Accident · Serious injuriesForeign investigationLancair LC41 · Gotha, GermanyMar 30, 2020 · N6504H · Substantial damage NTSB CEN19LA159Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Cleburne, TXA total loss of engine power due to oil starvation as the result of the oil pressure switch failure due to a manufacturing defect.May 30, 2019 · N2514F · Substantial damage NTSB GAA17CA174Accident · Minor injuriesData collectionFinal reportLancair Columbia 400 · Henderson, NVThe pilot’s improper decision to land the airplane with a gusting crosswind, which resulted in a loss of airplane control.Mar 5, 2017 · N2516K · Substantial damage NTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.Nov 22, 2016 · N169WT · Substantial damage NTSB CEN11LA577Accident · Minor injuriesLimited investigationFinal reportCessna 400 · Eastland, TXA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. .Aug 14, 2011 · N2515G · Substantial damage NTSB CEN11FA227Accident · No injuriesField investigationFinal reportLancair LC41-550FG · Carbondale, ILThe fatigue fracture and subsequent failure of the No. 2 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.Mar 11, 2011 · N521RT · Substantial damage NTSB LAX08LA217Accident · No injuriesLimited investigationFinal reportLancair LC41-550FG · Hailey, IDThe loss of directional control while taxiing due to the failure of the right brake.Jul 6, 2008 · N2544W · Substantial damage NTSB SEA08FA078Accident · 1 fatalField investigationFinal reportLancair LC41 · Portland, ORThe pilot's failure to follow the missed approach procedure. Contributing to the accident were the fog and below landing minimums visibility conditions.Feb 16, 2008 · N621ER · Destroyed NTSB SEA07FA247Accident · 6 fatalField investigationFinal reportLancair LC41-550FG · Kernville, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. Contributing to the accident was the pilot's failure to maintain an adequate airspeed.Sep 1, 2007 · N2520P · Destroyed NTSB NYC06FA072Accident · 4 fatalField investigationFinal reportLancair LC41-550FG · Stafford, VAThe pilot's failure to execute the published missed approach. Factors included the night lighting conditions, low ceilings and fog.Feb 23, 2006 · N400WX · Destroyed NTSB LAX06FA014Accident · 3 fatalField investigationFinal reportLancair LC-41-550FG · Warner Springs, CAThe flight crew's failure to maintain adequate terrain clearance and their decision to continue flight into known adverse weather conditions. Contributing to the accident was overcast conditions, and terrain obscuration. A finding of the investigation is that…Oct 17, 2005 · N285JB · Destroyed NTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…Aug 27, 2003 · N166PD · Destroyed