NTSB investigations, IN
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\" = 'IN' 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" = 'IN' 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 CHI82DA094Accident · No injuriesFinal reportCessna 172 · Clarksville, INThe pilot reported that the wind was blowing at 12 knots when he took off on a local flight. However, when he returned to land, it was from 270 degrees at about 30 knots. While landing on runway 18, the aircraft veered off the left side of the runway into…NTSB CHI82FA091Accident · 1 fatalField investigationFinal reportCessna 421 · Richmond, INDuring a VOR approach to runway 05 when 3 miles away from the airport at minimums ground contact was not made. The pilot stated that she elected to perform a missed approach but before power was applied the copilot raised the flaps. She further stated that…NTSB CHI82DA087Accident · No injuriesFinal reportCessna 182 · Lake Village, INThe pilot reported that the wind was from the west at 25, gusting 40 knots. During landing on runway 36, he touched down long and then attempted to go-around. At the north end of the field, the aircraft encountered soft, soggy terrain, the pilot lost…NTSB CHI82IA082Incident · No injuriesIncident investigationFinal reportSwearingen SA-266TC · South Bend, INThe captain reported that at lift-off above VI speed, he heard a loud pop that sounded like a tire had failed. A "bright yellowish" illumination was then seen in front of the right engine. There was insufficient runway to abort, so the takeoff was continued.…NTSB CHI82DA080Accident · No injuriesFinal reportCessna 150 · Charlestown, INThe pilot reported that he ran out of fuel on a cross-country flight. He made an emergency landing in an open field at night. During the landing, the plane flipped over on its back.NTSB CHI82DA078Accident · No injuriesFinal reportPiper PA-30 · Valparaiso, INThe pilot reported encountering severe icing conditions after he had canceled his IFR flight plan and had the airport in sight. At that point, he felt that the safest alternative was to continue the approach. The approach was flown at 120 mph with no flaps.…NTSB CHI82DA064Accident · No injuriesFinal reportFairchild Hiller 227C · Bloomington, INThe aircraft was being pre-positioned for a scheduled flight. During a visual approach to land, the captain (PIC) called for the flaps to be lowered in incremental settings (16.5, 27 & 40 deg). The flap handle was moved to the appropriate positions, but…NTSB CHI82DA062Accident · No injuriesFinal reportBeech 56TC · Huntington, INDuring a night touch and go landing, the aircraft veered left and struck a snowberm as the pilot was adding power to takeoff. Snowberms were located inside of the runway lights making the usable runway less than 75 ft and possibly restricting the lighting.…NTSB CHI82FA048Accident · 1 fatalField investigationFinal reportPiper PA-23 · Corydon, INPrior to this flight, the aircraft had not been flown for an extended period. On the day of the accident, it had been sold. The aircraft did not have a current annual inspection and had several maintenance discrepancies. These included problems that prevented…NTSB CHI82DA051Accident · No injuriesFinal reportCessna 152(II) · Fort Wayne, INThe student was on his sixth touch-and-go landing when the mishap occurred. After landing and before adding power to takeoff, he looked into the cockpit to retract the flaps and remove carburetor heat. During this time, the student lost directional control…NTSB CHI82DA055Accident · No injuriesFinal reportPiper PA-38-112 · Lebanon, INWhile the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The…NTSB CHI82DA042Accident · Minor injuriesFinal reportPiper PA-28-161 · Valparaiso, INThe right wing was observed rising and left wing striking the runway during the student pilot's third touch and go on an initial solo flight. When the main gear settled on to the runway the right wing again lifted into the air and the left wing struck a…NTSB CHI82DA038Accident · No injuriesFinal reportCessna 172 · Greencastle, INThe student arrived at the airport on a cross-country flight and requested landing advisories on the UNICOM frequency. The student stated that somebody replied that runway 18 was in use. Before landing, the pilot overflew the airport 4 times. Two of these…NTSB CHI82DA037Accident · No injuriesFinal reportErcoupe 415-C · Brownsburg, INThe pilot reported that during his visual approach for landing, he used full carburetor heat and cleared his engine during the base turn. While entering his final approach, he was too high and reduced his power below 1000 RPM for about 10 to 20 seconds. He…NTSB CHI82DA034Accident · No injuriesFinal reportBell 206L-1 · Indianapolis, INThe engine lost power during a night flight while enroute to obtain fuel. The low RPM audio and warning light were noted when the loss of power occurred. The pilot entered an autorotative descent and turned to land on an interstate highway. As he started to…NTSB CHI82DA033Accident · No injuriesFinal reportGrumman 1159 · Anderson, INBefore the aircraft arrived, the snow covered runway was plowed. A Cessna 182 pilot previously reported the braking action as fair to poor. The aircrew decided to land as close to the approach end as possible. The pilot reported that he had not been advised…NTSB CHI82FA019Accident · 2 fatalField investigationFinal reportCessna T337G · Fort Wayne, INOn 1/31/83 at 2134 CST, the acft departed grand island, NE on an IFR flt plan to toledo, OH, with appx 125 gal of fuel on board. While en route, the plt received updated wx for toledo. At that time, the toledo wx was indefinite 100 ft obscd, vis 1-1/2 mi with…NTSB CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INNTSB CHI82FEX06Accident · No injuriesClosedCessna 182G · Jeffsonville, INNTSB CHI82DEX03Accident · No injuriesClosedPiper PA-28 · Lafayette, INNTSB CHI82DEX02Accident · No injuriesClosedPiper PA-22 · Anderson, INNTSB CHI82FEX01Accident · Serious injuriesClosedPiper PA-31T · Madison, INNTSB CHI82DET02Accident · No injuriesClosedGulfstream AA-5A · Peru, INNTSB CHI82FA012Accident · 1 fatalClosedCessna 150 · Palmyra, INNTSB CHI82FA008Accident · 2 fatalClosedPiper PA-28 · Mooresville, INNTSB CHI82FA007Accident · 4 fatalClosedCessna 172 · Kokomo, INNTSB CHI82FET01Accident · No injuriesClosedCessna 150 · Ft Wayne, INNTSB CHI81FEX30Accident · No injuriesClosedPiper PA-28 · Noblesville, INNTSB CHI81FEX29Accident · No injuriesClosedAerospatial AS350D · Lynnville, INNTSB CHI81FEX22Accident · Minor injuriesClosedCessna 152 · Cayuga, INNTSB CHI81DEV35Accident · Minor injuriesClosedGrumman G-164A · Dana, INNTSB CHI81FET14Accident · 1 fatalClosedPDQ 2D · Goshen, INNTSB CHI81FET15Accident · No injuriesClosedBeech V35B · Ft Wayne, INNTSB CHI81FET13Accident · Minor injuriesClosedCessna 172E · Laporte, INNTSB CHI81FA098Accident · No injuriesClosedCessna 172N · Muncie, INNTSB CHI81DEX27Accident · No injuriesClosedCessna 182RG · West Middleton, INNTSB CHI81DEX26Accident · No injuriesClosedCessna 152 · Shelbyville, INNTSB CHI81FEX25Accident · Serious injuriesClosedN American AT-6G · Indianapolis, INNTSB CHI81FET10Accident · No injuriesClosedMooney M20F · South Bend, INNTSB CHI81FEX23Accident · No injuriesClosedGrum-Amer AA-5A · Waveland, INNTSB CHI81FET09Accident · No injuriesClosedCessna R182 · Plymouth, INNTSB CHI81FA068Accident · 4 fatalClosedGrum Amer AA-5A · Mccordsville, INNTSB CHI81FEX20Accident · No injuriesClosedGrumman G-164A · Remington, INNTSB CHI81FEX21Accident · No injuriesClosedTaylorcraft BC-65 · Paoli, INNTSB CHI81DEX24Accident · No injuriesClosedCessna 152 · Sedalia, INNTSB CHI81FEX19Accident · Serious injuriesClosedCessna 172N · Jasonville, INNTSB CHI81FEX18Accident · Minor injuriesClosedCessna 210J · Wirt, INNTSB CHI81FEX17Accident · No injuriesClosedCessna 402 · Jeffersonville, INNTSB CHI81FET08Accident · Minor injuriesClosedPiper PA-28 · Syracuse, INNTSB CHI81FEX16Accident · Serious injuriesClosedSchweizer 2-33A · Zionsville, IN