NTSB investigations, MI
28 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1984 | 4 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 4 |
| 2002 | 1 |
| 2006 | 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 c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 CHI06CA106Accident · No injuriesData collectionFinal reportWaco EQC-6 · Battle Creek, MIThe maintenance facility failed to properly install and inspect the rudder cable system resulting in the reversed rudder condition which made directional control not possible during the aborted takeoff. A contributing factor was an inadequate preflight…NTSB CHI06LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Alpena, MIThe station agent's inability to maintain control of the stroller when he lost his balance exiting the airplane's cargo compartment, allowing it to be blown into the operating right propeller. A factor was the high, gusty winds.NTSB CHI02LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Gregory, MIAn improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…NTSB CHI01LA332Accident · Serious injuriesLimited investigationFinal reportAviaStrottel AC 4C · Marshfield, MIThe pilot's decision to release from the tow plane during the takeoff. A factor associated with the accident was the pilot's vision was restricted by his hat during the takeoff.NTSB CHI01LA296Accident · No injuriesLimited investigationFinal reportDassault/SUD Fan Jet Falcon · Detroit, MIThe wheels up landing performed by the flightcrew during the emergency landing and improper aircraft preflight by the pilot in command. Factors were the unsecured cargo door, the cemetery fence, and the lack of crew coordination during the flight.NTSB CHI01LA245Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Detroit, MIThe passenger (an off duty flight attendant) disregarded the flight crews warning regarding turbulence along with the seat belt sign which had been turned on.NTSB CHI01LA268Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Gladwin, MIThe pilot's poor decision to exit the airplane onto the wing while the propeller was running.NTSB CHI97LA268Accident · No injuriesLimited investigationFinal reportBeech G35 · Belleville, MIthe pilot's improper planning/decision by failing to assure that the airplane was either tied down or chocked prior to pulling the propeller through, which started the engine with no one at the controls.NTSB CHI96LA206Accident · Serious injuriesLimited investigationFinal reportMitchell T Champabria · Kalamazoo, MIthe pilot's improper positioning of the throttle, while hand propping the aircraft engine, and his failure to either obtain proper assistance or properly secure the airplane.NTSB CHI94LA227Accident · No injuriesLimited investigationFinal reportCessna 441 · Flint, MIAn inadequate preflight inspection of the airplane by the pilot. Factors associated with this accident were unlatched nose cargo doors and the pilot's failure to extend the landing gear.NTSB CHI94LA016Accident · No injuriesLimited investigationFinal reportCessna 150J · Grosse Ile, MIThe pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…NTSB CHI92LA143Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Ionia, MIThe pilot-in-command's improper preflight and decision to close the glider's canopy at low altitude.NTSB CHI91LA231Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIA collision with wires after the glider overshot the landing area due to inadvertent lowering of the flaps and no use of spoilers.NTSB CHI91LA179Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Battle Creek, MIAircraft control by the dual student was not maintained, remedial action by the CFI was delayed, which resulted in a stall/mush. A factor related to the accident was rough water caused by a power boat wake.NTSB CHI91DEM03Accident · No injuriesFinal reportHuddleston/Becktold Glasair · Lansing, MIFailure of the instructor pilot (CFI) to maintain sufficient airspeed on final approach to flare the aircraft for landing. Factors related to the accident were: the landing gear malfunction, and the cfi's improperly planned approach.NTSB CHI91IA041Incident · No injuriesIncident investigationFinal reportBoeing 727-257 · Detroit, MIThe inadequate deicing procedures instituted by company management.NTSB CHI90DEC05Accident · No injuriesFinal reportSchleicher ASW-22 · Richmond, MIThe pilot's premature retraction of the flaps allowing the glider to settle into an unusually low tow altitude.NTSB CHI89DEM08Accident · No injuriesFinal reportMooney M20 · West Branch, MIThe pilot's decision to hand prop the engine with a non-pilot at the controls and the passenger's application to full throttle. A factor related to the accident was panic of the passenger.NTSB CHI89LA158Accident · No injuriesLimited investigationFinal reportBeech S35 · Lindon, MIThe restricted movement of the ruddervator control due to undetermined reasons.NTSB CHI89DEM04Accident · No injuriesFinal reportCessna 175 · Lawton, MIThe pilot's delay in aborting takeoff and his excessive rate of descent at touchdown. A factor in the accident was the pilot's inadequate preflight planning.NTSB CHI88IA111Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Detroit, MINTSB NYC88LA074Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82 · Decatur, MIThe flight attendant was pulling a beverage cart up the aisle when the pad the coffee pot was resting on caught against a curtain. The pad was pulled off the cart and the full pot of coffee spilled in a passengers lap. The passenger service cart has a…NTSB CHI87FA081Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Detroit, MIDrg flt, united flt 108 recd info of a bomb threat. Due to a short time limit, specified in the threat, the flt divertedto Detroit & the slides were used to evacuate the acft; 8 of 10 slides deployed nmly & were used. The slide at door 4R didn't inflate &…NTSB CHI85IA296Incident · 1 fatalIncident investigationFinal reportPiper PA-28-180D · Lansing, MIWhile en route to jackson, MI, the owner/plt suffered an apparent heart attack. The passenger, who was a private plt, safely landed the acft at Lansing, MI. The owner/plt's wife said that he had a plt certificate, but she could not locate it. There was no…NTSB CHI85LA028Accident · Serious injuriesLimited investigationFinal reportSwift GC-1A · Fraser, MIAccording to the plt, he took off on rwy 18 & was climbing thru about 250 ft AGL when the eng lost power & he made a forced landing. However, a co-owner, who was on board, stated that the plt had retarded the throttle, then the acft stopped stopped climbing,…NTSB CHI85LA018Accident · No injuriesLimited investigationFinal reportHughes 500 · Grosse Ile, MIPlt attempted to start helicopter with main rotor blades tied down.NTSB CHI84LA244Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7B · Lake Orion, MIA 74 year old passenger in a balloon lost her footing during landing and fell on her arm. Later examination revealed that her arm was broken. The plt and another passenger were not injured. The plt reported that the passengers had been briefed on landing and…NTSB CHI84LA209Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martin, MIThe plt had landed on a dragstrip after he encountered deteriorating wx. When the wx improved, he took off & attempted to depart over a bleacher area. The plt had difficulty climbing over the bleachers & said 'noticed RPM at 2700, helicopter in a turn.' He…