NTSB investigations, IN
121 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 4 |
| 1984 | 5 |
| 1985 | 5 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 7 |
| 1997 | 9 |
| 1998 | 8 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 8 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
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\" = 'IN' 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\" = 250)
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' 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" = 250) 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 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 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 CHI07FA022Accident · 5 fatalField investigationFinal reportCessna T303 · Mill Creek, INThe pilot became spatially disoriented and as a result failed to maintain control of the airplane. Factors associated with the accident were the instrument meteorological conditions aloft and the pilot being fatigued.NTSB CHI06FA245Accident · 1 fatalField investigationFinal reportCirrus SR22 · Indianapolis, INThe pilot's failure to maintain sufficient airspeed, which resulted in a stall and subsequent spin. Contributing to the accident were the pilot's inadequate preflight planning, the overloaded condition of the airplane, and the CG aft of the CG limit.NTSB CHI05LA218Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Goshen, INGround resonance experienced by the pilots.NTSB CHI05FA081Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · West Lafayette, INThe pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…NTSB CHI04LA207Accident · No injuriesLimited investigationFinal reportSkystar Kitfox · Westfield, INthe failure of the pilot to maintain adequate airspeed resulting in a stall.NTSB CHI04LA103Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Marion, INThe pilot's inadequate preflight planning/decision to ensure adequate takeoff performance by the improper use of flaps and failure to establish the aircraft was within weight and balance limitations.NTSB CHI04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 · Florence, INThe pilot prematurely lifted off during the takeoff with inadequate airspeed which resulted in the airplane stalling. Factors associated with the accident were there unsuitable/rough terrain that the pilot used for takeoff.NTSB CHI03LA310Accident · No injuriesLimited investigationFinal reportCessna 182D · Rushville, INThe pilot failed to maintain control of the airplane during the initial takeoff climb which resulted in an inadvertent stall.NTSB CHI03LA074Accident · 1 fatalLimited investigationFinal reportNorth American/Aero Classics P-51D · Urbana, INThe pilot's failure to maintain aircraft control which resulted in a spin.NTSB CHI03LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Wheatfield, INThe pilot not maintaining aircraft control and the pilot's inadequate compensation for the gusting wind condition. Factors to the accident were the gusting wind condition and the inadvertent stall at a low altitude.NTSB CHI03LA009Accident · Minor injuriesLimited investigationFinal reportDavis Early Bird Jenny · Scottsburg, INThe pilot not maintaining aircraft control. Factors to the accident included the pilot's lack of familiarity with the airplane, which resulted in an inadvertent stall/spin at a low altitude.NTSB CHI02FA294Accident · 2 fatalField investigationFinal reportAviat S-2C · Sheridan, INThe pilot's failure to maintain adequate altitude and airspeed while performing an aerobatic maneuver. Contributing factors were the pilot-in-command exceeding the aircraft weight and balance, and his inadequate preflight planning/preparation.NTSB CHI02FA197Accident · 1 fatalField investigationFinal reportPiper PA-60 · Columbus, INThe pilot's failure to maintain control of the airplane during a missed approach. Additional factors included the operator's inadequate oversight, the pilot's improper in-flight decision, conditions conducive to pilot fatigue, fog, and night.NTSB CHI02LA155Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Alexandria, INThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was the low altitude.NTSB CHI02LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Valparaiso, INThe pilot not maintaining aircraft control while encountering windshear during initial climbout, resulting in a stall at a low altitude.NTSB CHI02FA094Accident · 2 fatalField investigationFinal reportPiper PA-31P · Daleville, INThe pilots failure to maintain control of the airplane during the instrument approach. The low overcast ceiling and the pilot's in-flight decision to execute the instrument approach in below minimum weather conditions were factors.NTSB CHI02LA051Accident · No injuriesLimited investigationFinal reportBeech S35 · Angola, INThe pilot 's failure to maintain adequate airspeed and encountered a stall on approach to land. The low altitude on final approach was a factor.NTSB CHI02FA025Accident · 2 fatalField investigationFinal reportCessna 150M · Dyer, INThe failure of the flight crew to maintain adequate airspeed, resulting in an inadvertent stall/spin and the flight instructor's inadequate supervision of the flight, his impairment due to the use of over-the-counter medication is a contributing factor.NTSB CHI02LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Wayne, INThe pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.NTSB CHI01LA131Accident · 1 fatalLimited investigationFinal reportMadsen Lancair 320 · Valparaiso, INThe pilot not maintaining aircraft control during the initial climb after takeoff and the inadvertent stall/spin. A factor to the accident was the pilot's total lack of experience in accident airplane.NTSB CHI00LA239Accident · Minor injuriesLimited investigationFinal reportKollier Pitts S1C · Salem, INThe pilot failed to maintain control of the airplane during an intentional inverted flat spin and the initial control inputs he used in an attempt to recover were improper. A factor associated with the accident was the pilot became disoriented during the…NTSB CHI00LA212Accident · 1 fatalLimited investigationFinal reportHess RH-1 Falcon · New Castle, INaircraft control not attained by the pilot.NTSB CHI00LA207Accident · Serious injuriesLimited investigationFinal reportChilian Kitfox 1200 IV · Lowell, INthe incapacitation of the pilot. Factors to the accident were the failure of the pilot to maintain flying speed and the subsequent stall.NTSB CHI00LA068Accident · No injuriesLimited investigationFinal reportBeech A23 · Knox, INthe instructor pilot not performing remedial action on the student's right drift during the flare. Factors were the student not maintaining directional control, the student not maintaining proper centerline alignment, and the snowbank.NTSB CHI00LA049Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Georgetown, INthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the gusty tailwind condition and the low altitude at which the helicopter was hovering.NTSB CHI99LA200Accident · Serious injuriesLimited investigationFinal reportGillmore Benson B&M · Greencastle, INthe failure of the cyclic control rod. Factors were aircraft control not possible for the pilot.NTSB CHI99LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vincennes, INthe pilot's failure to maintain directional control of the airplane during the soft field takeoff. Factors associated with the accident were inadequate airspeed and the cable fence which was contacted.NTSB CHI99FA053Accident · 1 fatalField investigationFinal reportCessna C-172R · Angola, INThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI98LA311Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Decatur, INthe pilot's failure to maintain adequate airspeed during the takeoff and his premature raising of the flaps which resulted in the stall/mush condition.NTSB CHI98LA277Accident · Serious injuriesLimited investigationFinal reportMarchetti Avenger Gryo Plane · Mentone, INthe pilot's lack of familiarity with the gyroplane's performance, and his improper in-flight decision to reduce engine power to idle which aggravated the gyroplane's nose down pitch and exceeded the gyroplane's back stick authority.NTSB CHI98LA204Accident · 1 fatalLimited investigationFinal reportCessna 172R · Greenfield, INthe pilot's incapacitation due to a heart attack. A factor in the accident was the passenger's, a non-pilot, improper recovery from a bounced landing which resulted in an overload failure of the nose gear.NTSB CHI98LA197Accident · No injuriesLimited investigationFinal reportWolfe Pulsar 582 · Greenfield, INthe pilot's failure to obtain control of the aircraft during the recovery from a stall. Factors associated with the accident were the intentional stall initiated and the low altitude which did not allow a full recovery from the stall condition.NTSB CHI98LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Tocsin, INthe pilot's failure to obtain adequate airspeed during the takeoff climb and the resulting inadvertant stall. A factor in the accident was the pilot's premature raising of the flaps.NTSB CHI98LA158Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffith, INThe aircraft's speed not maintained by the pilot, which resulted in the aircraft stalling in close proximity to the ground.NTSB CHI98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Mc Cordsville, INThe pilot's failure to maintain airspeed and control of the airplane. Factors were his self-induced pressure.NTSB CHI98LA014Accident · 2 fatalLimited investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain adequate airspeed during a go-around attempt which resulted in an inadvertent stall.NTSB CHI97LA295Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Greenwood, INthe student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.NTSB CHI97FA290Accident · 3 fatalField investigationFinal reportBeech 76 · West Lafayette, INthe inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.NTSB CHI97LA271Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Zionsville, INfailure of the pilot to maintain adequate airspeed, which resulted in a stall and subsequent spin. A factor associated with the accident was the pilot's lack of experience in this make and model of glider.NTSB CHI97FA208Accident · 1 fatalField investigationFinal reportCessna 150F · Gary, INthe pilot's not obtaining/maintaining airspeed which resulted in a stall.NTSB CHI97LA202Accident · Minor injuriesLimited investigationFinal reportNiquette Pietenpol GN-1 · Lake Village, INthe pilot's inability to maintain sufficient airspeed and climb.NTSB CHI97GA103Accident · Serious injuriesFinal reportBell OH-58A · Seymour, INimproper action(s) by one or more of the emergency response team members, during a hovering/loading sequence, which resulted in the helicopter's lateral center-of-gravity (CG) limitations to be exceeded. A factor associated with the accident was: the pilot's…NTSB CHI97LA089Accident · No injuriesLimited investigationFinal reportCessna 150 · Petersburg, INThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Low altitude flight is a contributing factor.NTSB CHI97LA086Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Greencastle, INThe student pilot's improper recovery from a bounced landing.NTSB CHI96FA322Accident · 1 fatalField investigationFinal reportMankovich Sonerai · Jeffersonville, INinadequate maintenance and inspection of the airplane by the pilot/owner and other airframe and powerplant mechanics, which failed to assure adequate sealing of the engine firewall, and led to the pilot's incapacitation due to carbon monoxide.NTSB CHI96FA318Accident · 2 fatalField investigationFinal reportBeech 35-33 · Brownsburg, INfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent impact on a roadway. Buzzing by the pilot was a contributing factor.NTSB CHI96LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lafeyette, INthe pilot's failure to maintain directional control during landing. Factors related to the accident were the pilot's inadequate compensation for the wind conditions and the crosswind.