NTSB investigations, 2007, IN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 per year
| 1963 | 1 |
|---|---|
| 1964 | 107 |
| 1965 | 116 |
| 1966 | 119 |
| 1967 | 132 |
| 1968 | 106 |
| 1969 | 88 |
| 1970 | 83 |
| 1971 | 81 |
| 1972 | 88 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 86 |
| 1976 | 78 |
| 1977 | 90 |
| 1978 | 95 |
| 1979 | 70 |
| 1980 | 76 |
| 1981 | 52 |
| 1982 | 55 |
| 1983 | 54 |
| 1984 | 55 |
| 1985 | 54 |
| 1986 | 58 |
| 1987 | 53 |
| 1988 | 66 |
| 1989 | 45 |
| 1990 | 42 |
| 1991 | 33 |
| 1992 | 29 |
| 1993 | 35 |
| 1994 | 38 |
| 1995 | 33 |
| 1996 | 31 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 22 |
| 2000 | 34 |
| 2001 | 29 |
| 2002 | 25 |
| 2003 | 20 |
| 2004 | 26 |
| 2005 | 20 |
| 2006 | 28 |
| 2007 | 23 |
| 2008 | 22 |
| 2009 | 30 |
| 2010 | 27 |
| 2011 | 26 |
| 2012 | 26 |
| 2013 | 22 |
| 2014 | 16 |
| 2015 | 19 |
| 2016 | 23 |
| 2017 | 22 |
| 2018 | 19 |
| 2019 | 22 |
| 2020 | 17 |
| 2021 | 21 |
| 2022 | 21 |
| 2023 | 16 |
| 2024 | 17 |
| 2025 | 13 |
| 2026 | 9 |
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 year(c.\"eventDate\") = 2007
AND 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 year(c."eventDate") = 2007 AND 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 CHI08LA052Accident · Serious injuriesLimited investigationFinal reportLevick RAF-2000-GTX-SE · Salem, INThe pilot's failure to maintain control of the gyroplane during climbout after takeoff.NTSB CHI08CA020Accident · Serious injuriesData collectionFinal reportSchweizer 269C · Hazelton, INThe pilot's failure to maintain adequate main rotor speed during the intentional autorotation, and his subsequent inability to reduce the descent rate prior to impact. A contributing factor was the intentional autorotation initiated by the pilot.NTSB CHI08CA034Accident · Minor injuriesData collectionFinal reportGluff, Alan Zenair 200 · Greenwood, INThe total loss of engine power due to a lubricating system leak for undetermined reasons which resulted in engine seizure, and the unsuitable terrain encountered during the forced landing. Contributing factors were the plowed field and the nose gear failure…NTSB CHI08CA035Accident · No injuriesData collectionFinal reportMooney M20E · Lafayette, INThe improper installation of the connecting rod bolts during major overhaul, which resulted in the separation of the connecting rod from the crankshaft in flight. Contributing to the accident was the rising terrain encountered during touchdown and the…NTSB CHI07LA287Accident · No injuriesLimited investigationFinal reportMooney M20K · Fort Wayne, INA total loss of engine power due to the fatigue failure of one of the number two cylinder connecting rod bolts.NTSB CHI07CA278Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Hagerstown, INThe pilot's use of an unsuitable runway for takeoff and delayed aborted takeoff. Factors were the wet grass and the fence the airplane impacted and subsequently nosed over.NTSB CHI07LA273Accident · 1 fatalLimited investigationFinal reportTerpstra Exec 162F · Winamac, INThe inadequate installation of the horizontal stabilizer bracket by the pilot, the fatigue fracture seperation of vertical stabilizer bracket during cruise flight, and the aircraft control not possible by the pilot.NTSB CHI07CA261Accident · No injuriesData collectionFinal reportCessna 210 D · Fort Wayne, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB CHI07CA262Accident · No injuriesData collectionFinal reportBeech BE-77 · Bloomington, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB CHI07LA252Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Knox, INThe in-flight encounter with turbulence.NTSB CHI07LA289Accident · No injuriesLimited investigationFinal reportCessna 310Q · Brownsburg, INThe pilot's poor in-flight planning to make an off airport precautionary landing and his failure to maintain clearance from the construction equipment during the landing roll. Contributing to the accident was the construction equipment.NTSB CHI07LA208Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Osceola, INThe pilot's failure to maintain clearance with the trees during the aerial application flight. Factors associated with the accident were the trees and the pilot's lack of experience in flying aerial application flights.NTSB CHI07CA192Accident · No injuriesData collectionFinal reportCessna 150M · Muncie, INThe pilot's failure to maintain sufficient airspeed, resulting in a stall/mush during an attempted aborted landing. A factor in the accident was the premature flare and the pilot's inadequate recovery from a bounced landing.NTSB CHI07LA198Accident · No injuriesLimited investigationFinal reportAyres S2R-T15 · Marion, INThe loss of engine power for undetermined reasons during an aerial application. A contributing factor was the creek bed.NTSB CHI07CA156Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Elwood, INThe commercial pilot's failure to maintain adequate altitude and airspeed which resulted in the airplane mushing into the terrain during the simulated forced landing along with the CFI's failure to adequately supervise the commercial pilot's actions.NTSB CHI07CA152Accident · No injuriesData collectionFinal reportCessna 421C · Kokomo, INThe pilot not obtaining proper alignment with the runway during the emergency landing after takeoff, which imparted an excessive side load on the landing gear. Factors contributing to the accident were the unstabilized approach and engine shutdown due to the…NTSB CHI07LA151Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Fishers, INThe fatigue separation of the engine mount's nose gear actuator attachment foot during landing.NTSB CHI07CA139Accident · No injuriesData collectionFinal reportCessna 150 · English, INThe pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.NTSB CHI07FA114Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Bass Lake, INThe pilot's failure to maintain a proper approach glidepath, which resulted in a settling-with-power flight condition. Contributing to the accident was the dark night light condition.NTSB CHI07LA095Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Austin, INThe pilot's improper preflight planning/preparation, and his failure to abort the takeoff. Contributing factors were a tailwind and a short runway.NTSB CHI07FA084Accident · 2 fatalField investigationFinal reportBeech 58 · Munster, INThe fuel starvation for an undetermined reason which led to the loss of power on the left engine. Additional causes were the pilot's failure to maintain airspeed which led to his loss of control of the airplane. Factors in the accident were the flight…NTSB CHI07FA079Accident · 2 fatalField investigationFinal reportCessna 150M · Bedford, INSuicide.NTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.