NTSB investigations, MO

62 cases where the sequence of events included Loss of engine power (total).

Cases, newest first

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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB CEN10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Centerville, MOA loss of engine power due to carburetor icing as a result of the pilot not using carburetor heat.Jul 2, 2010 · N5798P · Substantial damageNTSB CEN10CA313Accident · No injuriesData collectionFinal reportLuscombe 8F · Shell Knob, MOA total loss of engine power for undetermined reasons.Jun 10, 2010 · N9932C · Substantial damageNTSB CEN10CA214Accident · No injuriesData collectionFinal reportStinson 108-2 · Dexter, MOA loss of engine power for an undetermined reason.Apr 17, 2010 · N988D · Substantial damageNTSB CEN10LA171Accident · No injuriesLimited investigationFinal reportLoehr Thomas H Zenith Stol CH701 · Eldon, MOA loss of engine thrust during takeoff due to the failure of the engine-to-propeller drive belts as a result of improper belt tension. Contributing to the accident was the non-certificated pilot's improper preflight inspection.Mar 22, 2010 · N144AC · Substantial damageNTSB CEN10LA168Accident · No injuriesLimited investigationFinal reportCessna 182G · Mount Vernon, MOA loss of engine power due to the failure of the number four connecting rod for undetermined reasons.Mar 18, 2010 · N2381R · Substantial damageNTSB CEN10CA060Accident · No injuriesData collectionFinal reportBoeing B75N1 · St. Louis, MOA loss of engine power for undetermined reasons.Nov 22, 2009 · N5521N · Substantial damageNTSB CEN09LA576Accident · No injuriesLimited investigationFinal reportCessna 170A · Grain Valley, MOA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Sep 6, 2009 · N9129A · Substantial damageNTSB CEN09CA468Accident · No injuriesData collectionFinal reportCorvus Carone MK 1 · Lee's Summit, MOA loss of engine power for undetermined reasons.Jul 23, 2009 · N51299 · Substantial damageNTSB CEN09CA423Accident · No injuriesData collectionFinal reportLewis Keith O Viggenite · Chesterfield, MOThe loss of engine power for unknown reasons.Jul 8, 2009 · N20VV · Substantial damageNTSB CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.Dec 5, 2008 · N1521Q · Substantial damageNTSB CEN09LA051Accident · Serious injuriesLimited investigationFinal reportJohnson Leonard G Cozy MK-IV · Osceola, MOA total loss of engine power due to an obstruction of airflow as a result of the pilot's inadvertent actuation of the landing brake.Nov 5, 2008 · N637PS · Substantial damageNTSB DEN08LA081Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Mosby, MOA loss of engine power for reasons undetermined, and the pilot's decision to discontinue the autorotation when he thought engine power had been restored. Contributing to the accident were the low altitude and excessive airspeed.Apr 18, 2008 · N56895 · Destroyed