NTSB investigations, MI
12 cases where NTSB found Aircraft structures.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2021 | 1 |
| 2023 | 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.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0103'))
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."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0103')) 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 CEN23LA200Accident · No injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Gregory, MIThe pilot’s improper landing flare that resulted in a hard, bounced landing and subsequent overstress failure of the nose landing gear.NTSB CEN21LA420Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Ultralight Challenger II · Rogers City, MIThe separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…NTSB CEN15FA386Accident · 1 fatalField investigationFinal reportBarrow Ted A ONE Easy · Battle Creek, MIThe pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.NTSB CEN14LA419Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · South Haven, MIThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.NTSB CEN14LA202Accident · 2 fatalLimited investigationFinal reportNanchang CJ6 - A · Flushing, MIThe pilot’s failure to maintain adequate airspeed during an off-airport forced landing after a loss of engine power due to carburetor icing and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to…NTSB CEN13IA355Incident · No injuriesIncident investigationFinal reportRockwell International 114 · Lapeer, MIThe malfunction of the pilot’s seat-latching mechanism due to a bent rod, which allowed the seat to come loose and slide full aft and resulted in a temporary loss of airplane control.NTSB CEN12LA578Accident · 2 fatalLimited investigationFinal reportDestiny XLT · Hart, MIThe partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.NTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.NTSB CEN09LA353Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103C Twin III Acro · Gregory, MIThe pilot's failure to maintain sufficient airspeed during the turn to return for landing, which resulted an inadvertent stall/spin. Contributing to the accident was the failure of the ground winch tow cable shortly after takeoff.NTSB CHI08CA298Accident · No injuriesData collectionFinal reportLake LA-4 · Algonac, MIThe amphibious airplane's collision with submerged debris during taxi for takeoff, and the resulting damage to the hull.NTSB CHI08CA116Accident · Minor injuriesData collectionFinal reportMooney M20J · Howell, MIThe inadvertent stall and low airspeed while maneuvering back to the departure airport after the baggage door opened in flight. An additional cause was the plot's diverted attention to the opening of the baggage door.NTSB CHI08IA109Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Pontiac, MIThe inadvertent stalling of the rudder trim actuator motor during flight due to the pilot's unintentional exceedence of the motor's design limit for stalling while accelerating after completing a simulated engine-out maneuver.