FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Accident 20010627017139ABbavia 8GCBC · Berlin, MD(-23) On 06/27/2001 Mr. Nathan adam kramer, while acting as pilot in command, lost control during a landing at (4MD1) bunting field located in Berlin, MD. Mr. Kramer landed runway 36 and veered off the runway striking a pile of dirt that was located about 20…Accident 20010627015949APiper PA18150 · Bryce Canyon, UT(-23) On June 27, 2001, at 1030 MDT, pilot scott jeffery kaats, certificate #558984824M attempted to land N872CC, apiper PA-18-150 at the Bryce Canyon Airport (bce) on runway 3. The winds were 12 knots at 120 degrees. One wheel touched dwon but the pilot…Incident 20010627015869IDoug DC932 · Richmond, VA(-23) No narrativeAccident 20010627015029AN5017H · Clear, AK(-23) Helicopter was on approach to helipad when he saw another helicopter on the pad. He decided to orbit until the other helicopter exited the helipad. At approximately 400 ft AGL and 50 knots the pilot heard a sudible warning tone and saw a split in the…Incident 20010627014959IBeech V35B · Olivebranch, MS(-23) Pilot took off at mckenzie, TN @ 0800 local. Traveled to olive branch, MS. After landing, during rollout, nose landing gear collapsed.Incident 20010627013809IUnivar 1082 · Winchester, VA(-23) Pilot landed long on the 2,100 foot runway and ran off the end of the runway into a ditch. The aircraft tipped over on to the propeller causing minor damage. The pilot then observed that he landed with a slight tailwind.Accident 20010626039959ACessna 150D · Soldotna, AK(-23) On June 26, 2001, N73CC, a Cessna 150-D airplane crashed and was destroyed about 300 yards from a private landing field. The owner of the private airfield is [privacy data omitted] said that Mr. Faass, pilot of the Cessna 150-D, had washed the airplane…Incident 20010626037959IAirtrc AT502 · Clewiston, FL(-23) On 06/26/01 about 1000 EDT, during takeoff roll, aircraft left wheel hit a soft sand spot and it pulled the aircraft off dirt runway. As a result, the propeller struck the ground. No injuries reported. Aircraft sustained minor damage. Maintenance…Accident 20010626020319ABbavia 7KCAB · Hudson, MI(.19) On June 26, 2001, at 2030 eastern daylight time, a Bellanca 7KCAB, N86960, operated by a private pilot, sustained substantial damage during a forced landing on a road at Hudson, Michigan. Prior to the accident the pilot reported the airplane lost engine…Accident 20010626017969AKaman HH43B · Mullanpass, ID(-23) Helicopter was at hover with "long-line" attempting to lift logs. A loud "bang" was hear/felt, the helicopter lost power and began a descent. Pilot instinctively aimed for some snags. Aircraft made hard landing involving snags. Main rotor blades…Accident 20010626016739ABbavia 8GCBC · Paris, TX(-23) On 06/26/00 at 16:15 CDT, an American champion 8GCBC single-engine airplane N249SF, while taking off from cox field airport, Paris, TX. Was substantially damaged. The pilot in command (PIC) reported that she was monitoring the takeoff by the student…Accident 20010626015969APiper PA38112 · Bozeman, MT(-23) Pilot stated that he was flying N9341T and was to the right side of N80830 and 100 feet below. He then started a crossover maneuver going under and to the left. His aircraft accelerated and hit updraft causing the tail of his airplane to strike the prop…Accident 20010626015929AAmtr Venture · Grass Valley, CA(-23) Upon landing the nose wheel failed to remain centered and caused aircraft to veer right off runway. Aircraft struck runway sign, spun sideways, then struck a second runway sign before it came to a rest. (.4) on June 26, 2001, at 0840 hours pacific…Incident 20010626015189ICessna 172R · Daytona Beach, FL(-23)While taxing onto runway 7L at dayton Beach international airport, dayton Beach Florida, CE-172, N488ER, struck the rudder of CE-172, N470ER. CE-172, N470ER, was not moving when struck by N448ER. Both aircraft sustained minor damage.Accident 20010626015129ACessna 172M · Bozeman, MT(-23) Pilot stated she was lead aircraft in a flight of four when tomahawk N9341T passed under and in front of her. She then stated the tail of the tomahawk came up and struck the propeller of N80830. At that time all aircraft returned to Bozeman airport and…Accident 20010626014619APiper PA32300 · Quonochontaug, RI(-23) The aircraft departed block island state (bid) with one passenger on board when leveling off at 2800 ft., enroute to groton-new london (gon) airport, the engine stopped running. The pilot had the right main fuel tank selected prior to the engine…Accident 20010625039939APiper PA18150 · Koliganek, AK(-23) On June 25, 2001 a float equipped Piper PA-18-150 registered to the state of Alaska, piloted by james moen a certificated commercial pilot, crashed 10 miles NE of Koliganek, Alaska airstrip. NTSB and FAA inspectors arrived at the scene June 26, 2001 and…Accident 20010625033009ABlanca 14133 · Pierce, NE(-23) Pilot landed aircraft in pasture due to fuel starvation. The landing gear collapsed during rollout, causing left wing damage.Incident 20010625020869ICessna T210M · Flint, MI(-23) Pilot in command (PIC) left pontiac, Michigan (ptk) @ 1630 local time on June 25, 2001. This was to work with GPS unit (north star system) on approaches VMC with dan flavin a private pilot. Weather information was received from the television, as it was…Incident 20010625018449IPiper PA28181 · Westminister, MD(-23) Pilot departed chester county, (pa) airport (40N) on first solo cross country. Upon landing at Westminister (W54) aircraft porpoised, damaging nose gear. Student was endorsed for cross country by instructor david newell, certificate 2615362.Accident 20010625017759APiper PA28140 · Rochester, NY(-23) On Monday June 25, 2001, at 20:45 local time, a Piper PA-28-140 aircraft, bearing registration number N5265T, operating under 14 CFR part 91, impacted rising terrain at the greater Rochester international airport (roc), in Rochester, NY. The pilot of…Accident 20010625017179ACessna 172M · Napa, CA(-23) Post accident investigation revealed a bent pushrod on #1 cylinder exhaust valve. (.4) during the missed approach the engine lost power, was maneuvered to land, and came to rest inverted after the nose wheel touched down in soft dirt. The purpose of the…Accident 20010625016719AAmtr RV6 · Hammond, LA(-23) Pilot perished in accident.Accident 20010625016389ABeech 35B33 · Lakeside, CA(.19) On June 25, 2001, about 0954 hours pacific standard time, a Beech 35-B33, N22CR, co-owned and operated by the pilot, descended into residential terrain in the community of Lakeside, California. The accident site is about 3.3 nautical miles…Incident 20010625016359IBeech B60 · Red Wing, MN(-23) Landing gear would not fully retract after takeoff. Normal and emergency gear extension failed to extend landing gear. Aircraft made gear up landing.Incident 20010625016249ICessna 172RG · Jackson, MI(-23) Upon landing and subsequent rollout, nose gear retracted into wheel well, prop hit runway.Accident 20010625014129ALkheed P38L · Greenwood, MS(-23) During descent left engine started to backfire followed by a loud bang and filled the cabin with smoke. The left engine continued to burn. Pilot landed aircraft gear up in cotton field. (.19) on June 25, 2001, about 0920 central daylight time, a…Accident 20010624039319AArctic S1B2 · Petersburg, AK(-23) On rollout after a beach landing, right wheel contacted a soft area of water over sand and aircraft inverted, engine was in a power down mode and prop was not damaged. Right wing strut was bent (bowed) and windshield was cracked. No other damage was…Accident 20010624024509AAmtr STARDUSTR300 · El Cajon, CA(-23) On June 24, 2001, at about 0705 PDT, an experimental stolp starduster SA-300, N711MH, operated by the pilot, Mr. Lawrence j. king, sustained substantial damage when it groundlooped during landing on runway 27R at san diego Gillespie Field Airport…Incident 20010624023819IUnivar 415C · Farmersville, OH(-23) On 24 June 2001 at approximately 1730 hrs esdst, Ercoupe 415-C, N94109 ran off the left side of the runway during a take-off to the east at the mcintosh airport (private) Farmersville, Ohio. Minor damage was sustained to the airframe. Weather was clear,…Accident 20010624023419ACessna 152 · Tampa, FL(-23) On June 24, 2001, at 2230 local time, a Cessna 152, N152LE, registered to leading edge aviation services, inc. collided with a hanger at vandenburg airport (X16), Tampa Florida, during taxi after a cross country solo. The aircraft was substantially…Accident 20010624023229ABeech 77 · Rock Hill, SC(-23) On June 24, 2001 at 1145 EST, a Beech skipper, BE-77, N3818D on landing at the country Squire airport (private), Rock Hill, SC, bounced, lost control and skidded to a stop at the departure end coming to rest in a ditch. The landing and sudden stop at…Accident 20010624020579AN4842 · Butler, GA(-23) Pilot of the aircraft was attempting to take off from a grass field, towing a glider. The aircraft struck the tops of trees at the departure end of the strip. The glider pilot released the tow rope at approx. 150 ft AGL, made a right turn, came around…Accident 20010624020299APiper PA28181 · Brooklyn, MI(.19) On June 24, 2001, at 1258 eastern daylight time, a Piper PA-28-181, N8210Z, piloted by a private pilot, was substantially damaged when the pilot landed long and the airplane overran the end of runway 01 (2,822 feet by 100 feet, dry/turf) at the Shamrock…Accident 20010624019619AAmtr Glasairiirg · Bolivar, MO(-23) On June 24, 2001, at 1300 CDT, a terminella glasair ii rg, N96L, piloted by a private pilot, was destroyed during an in-flight collision with terrain following a loss of control during initial climb from runway 18 (3,399 feet by 60 feet, dry/asphalt) at…Accident 20010624018029APiper PA12 · Eagle, CO(-23) Pilot encountered rising terrain and tail wind while attempting a landing at a mountain clearing (11,100 ft. elevation).Incident 20010624017329IBeech C24R · Gaithersburg, MD(-23) During simulated engine failure while in pattern for runway 32, aircraft touched down and the left main gear collapsed. Pilot/instructor giving check ride stated that he put gear down and had green light when aircraft touched down left main gear…Incident 20010624016529ILodi, CA(-23) Mr, torsten pohlschneider performed a tandem jump on June 22, 2001, attended a six-hour ground school on June 23, 2001, and performed two static line jumps on June 24, 2001. On his third jump on that day, the main parachute developed a malfunction…Accident 20010624016409AUnivar 415CD · Mcalester, OK(.19) On June 24, 2001, approximately 1500 central daylight time, a Ercoupe (eng & research corp.) 415-CD airplane, N3962H, was destroyed when it impacted terrain during the initial takeoff climb from the Mcalester regional airport (mlc), Mcalester, Oklahoma.…Incident 20010624015749IBbavia 7ECA · Marble Falls, TX(-23) During the landing roll on runway 17, the aircraft abruptly departed the left side of runway coming to rest approximately 50 yards from the runway centerline. The pilot stated that the landing was normal until touch down when the aircraft started…Accident 20010624015659AHughes 269A · Pasorobles, CA(.19) On June 24, 2001, about 1930 hours pacific daylight time, a Hughes 269A, N8724F, operated by del rio aviation of paso robles, California, sustained substantial damage during an instructional maneuver at paso robles. The certified flight instructor…Incident 20010624015499IPiper PA28161 · Grandbay, AL(-23) On June 24, 2001, at approximately 1200 CDT, a Piper PA-28-161, N35671, registered to knox c. mcleod iii, made an emergency landing in a field due to engine problems. The aircraft sustained minor damage to the propeller and there were no injuries. The…Incident 20010624014869ICessna 172RG · Miami, FL(-23) Pilot selected gear down and did not get a safe gear indication. Emergency extension was initiated and was unsuccessful. Pilot landed aircraft with nose gear retracted. The aircraft sustained minor damage to the nose section.Accident 20010624014489ARobsin R22BETA · Garner, NC(.19)On June 24, 2001, about 1540 eastern daylight time, a Robinson R-22B, N7119D, registered to a private individual, operating as a title 14 CFR part 91 personal flight, sustained a roll over in the vicinity of Garner, north carolina. Visual meteorological…Incident 20010624013569IBbavia 7FC · Rock Springs, WY(-23) The pilot lost directional control on takeoff in gusty wind.Accident 20010623039339APiper PA28140 · Katzehin Flat, AK(-23) Aircraft had 3 persons on board, take off area was a beach wide, Flat and slightly soft sand and gravel. Aircraft broke ground only in ground effect. Wind down draft would not allow aircraft to climb and it settled back on ground at end of Flat take off…Accident 20010623033529ABalwks FIREFLY8B15 · Mc Kinney, TX(-23) Mr. George, a lta commercial pilot, was imparting instruction to a student pilot. The student pilot was having difficulty with landings. All landings made prior to the accident were normal. Mr. George, acting as pilot-in-command, established a normal…Incident 20010623033189IPiper PA38112 · Tablerock, MO(-23) On June 23, 2001 at approximately 0930 hours local time, the pilot in command of a Piper tomahawk, PA-38-112, exited a Private airstrip at the departure end of the landing runway and proceeded to a designated parking area abeam a "fly-in" reception…Incident 20010623022589ICessna 172RG · Chicago/Waukega, IL(-23) On June 3, 2001, Cessna 172RG, N9877B, piloted by a private pilot, departed Waukegan airport, Waukegan, IL for a part 91 personal flight to oshkosh, Wisconsin. When the landing gear was lowered for landing, the left main landing gear did not lock into…Incident 20010623021259ISaab 340B · Chicago, IL(-23) On landing approach, approximately 6 miles out, the aircraft started shaking violently. After a couple seconds, the right hand torque gauge started to fluctuate between 60% and 20% torque. Shut down the right engine and the violent shaking stopped.…