NTSB investigations, MI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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\" = 'MI' AND c.\"eventCountry\" = 'USA' 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' 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 CHI82DA041Accident · No injuriesFinal reportCessna 172 · Benton Harbor, MIThe pilot received a weather briefing at 1030 EST for a cross-country flight. The cross-country originated at Benton Harbor at 1100 EST using runway 27. At that time, the runway was bare and dry. The flight proceeded to battle creek and kalamazoo, and then…NTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…NTSB CHI82DA039Accident · No injuriesFinal reportPiper PA-28-181 · East Lansing, MIThe pilot initiated his takeoff on a snow covered, sod runway that had been plowed with a 50 ft wide strip. The plowed area had a snow base and there were four foot snow banks at the edges. Although the runway had been plowed on the previous night and it had…NTSB CHI82DA056Accident · No injuriesFinal reportCessna 340A · Near Lansing, MIDuring flight over lake Michigan at 13,000 feet, the pilot noticed that the throttle, mixture and propeller controls to one of the engines began binding. The controls to the other engine remained normal. He descended to 9000 feet and continued at reduced…NTSB CHI82DA028Accident · No injuriesFinal reportPiper PA-38-112 · Grand Rapids, MIThe pilot-in-command was a student on a check flight for a private license. The check pilot was an FAA inspector. The flight was conducted from an airport with runways that were partially covered with snow and ice. The mishap occurred while the pilot was…NTSB CHI82FEC08Accident · No injuriesFinal reportCessna 152 · Ypsilanti, MIDuring takeoff from a hard packed snow and icy runway the aircraft veered left into a snowbank off the side of the runway. The student pilot stated that prior to the takeoff roll he had full deflection of the left aileron and was anticipating with right…NTSB CHI82DA020Accident · No injuriesFinal reportCessna 150L · Charlotte, MIAfter returning to the airport, the pilot used full flaps during a crosswind landing. The wind was from 090 degrees, gusting 20 to 25 knots. The pilot stated that he added power when the aircraft stalled at about 10 ft AGL. The plane touched down in snow…NTSB CHI82FET03Accident · No injuriesClosedBeech 95-B55 · Dowagiac, MINTSB MKC82FA013Accident · 3 fatalClosedCessna T210N · Jackson, MINTSB CHI82FA018Accident · No injuriesClosedCessna T182Q · Lansing, MINTSB CHI82DEC07Accident · No injuriesClosedCessna 152 · Howell, MINTSB CHI82FEM05Accident · Serious injuriesClosedPiper PA-22 · Wayland, MINTSB CHI82FEM04Accident · Serious injuriesClosedCessna 172 · Kinross, MINTSB CHI82FEM02Accident · Minor injuriesClosedBeech T-34 · Lansing, MINTSB CHI82FEC06Accident · No injuriesClosedGrumman AA5B · Jackson, MINTSB CHI82DEM03Accident · No injuriesClosedCessna 177 · Mattawan, MINTSB CHI82DEP10Accident · Minor injuriesClosedGreat Lakes 2T-1A · Dalton, MINTSB CHI82FEC05Accident · Serious injuriesClosedPiper PA-22 · Howell, MINTSB CHI82FEC04Accident · No injuriesClosedBeech G-35 · Pontiac, MINTSB CHI82DEM01Accident · No injuriesClosedQuickie · Plainwell, MINTSB CHI82FEC03Accident · No injuriesClosedBeech A-35 · Troy, MINTSB CHI82FEC02Accident · 1 fatalClosedGulfstream AA-1B · Carsonville, MINTSB CHI82FEC01Accident · No injuriesClosedCessna 177A · Gibralter, MINTSB CHI82FA001Accident · 1 fatalClosedBeech D-18S · Fraser, MINTSB CHI81FA104Accident · 2 fatalClosedPiper PA-32 · Newberry, MINTSB CHI81FEC47Accident · No injuriesClosedPiper PA-34 · Linden, MINTSB CHI81FA103Accident · 4 fatalClosedMooney M20F · Detroit, MINTSB CHI81FA101Accident · 1 fatalClosedCessna 172 · Faithorn, MINTSB CHI81FEC46Accident · No injuriesClosedCessna A185F · Detroit, MINTSB CHI81FEC45Accident · No injuriesClosedCessna 182L · Brighton, MINTSB CHI81FET12Accident · Minor injuriesClosedBell 47J · Dowagiac, MINTSB CHI81FEM43Accident · No injuriesClosedAeronca 65-TC · Plainwell, MINTSB CHI81FET11Accident · 1 fatalClosedFairchild M-62A · Coldwater, MINTSB CHI81FEC44Accident · 1 fatalClosedLuscombe 8A · Farmington, MINTSB CHI81FEC43Accident · Serious injuriesClosedPitts S-1S · Romeo, MINTSB CHI81FEC42Accident · No injuriesClosedBellanca 7FC · Ann Arbor, MINTSB CHI81DEM41Accident · No injuriesClosedBeech B-23 · Marshall, MINTSB CHI81FEM42Accident · Serious injuriesClosedCessna C210 · Kalamazoo, MINTSB CHI81FA093Accident · 4 fatalClosedCessna 172N · Adrian, MINTSB CHI81DEM39Accident · No injuriesClosedCessna 150 · East Lansing, MINTSB CHI81DEM10Accident · No injuriesClosedPiper PA-38 · Saginaw, MINTSB CHI81FEM37Accident · No injuriesClosedPiper PA-28 · Cheboygan, MINTSB CHI81DEC41Accident · Minor injuriesClosedBlanik L-13 · Oxford, MINTSB CHI81DEM38Accident · No injuriesClosedCessna 150 · Mcbain, MINTSB CHI81FEM85Accident · No injuriesClosedLuscombe 8E · Gladwin, MINTSB CHI81FEM36Accident · Serious injuriesClosedPiper PA-28 · Mackinaw, MINTSB CHI81FEC40Accident · No injuriesClosedPiper PA-22 · Lapeer, MINTSB CHI81FEM33Accident · 3 fatalClosedVarieze RAF · Holland, MINTSB CHI81DEC39Accident · No injuriesClosedCessna 182 · Lapeer, MINTSB CHI81FEC48Accident · No injuriesClosedCessna 310N · Pontiac, MI