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.
Incident 20080707848269IDoug DC981 · St Louis, MO(-23) On Monday July 7, 2008 1455Z a Mcdonnell Douglas MD-81, N804ME operated by midwest airlines as a chartered flight #8663 departed chicago's midway (mdw) at approximately 1455Z. [privacy data omitted] Was onboard the chartered flight at the time of the…Accident 20080707843859ASchler ASK21 · Elmira, NY(-23) On July 7, 2008, at 1400 EDT, a 1984 schleicher glider model ASK-21, N363KS, s/n 21228, operated by [privacy data omitted] returned to land at the Harris Hill Airport (4NY8), in Elmira, NY, but came in too low on approach to land. The pilot extended the…Accident 20080707841889ACessna 140 · Goffs, CA(-23)While cruising at 6500 feet, the engine began sputtering. The pilot elected to make a precautionary emergency landing on traffic free. Goffs road. Us interstate 15, intersects Goffs road at 1/8 mile away. The landing occurred at a non populated remote…Accident 20080707841639AAmtr Sportstar · Arlington, WA(-23) Student pilot was on takeoff roll beginning a solo flight observed by CFI on ground. At rotation speed he rotated the nose up and felt the aircraft turn to the left due to what he believed was a wind gust. He applied full right rudder to compensate with…Accident 20080707841129ATcraft 20 · Big Creek, ID(-23) Pilot stated that he landed long and fast at this short, high altitude, mountain airstrip. He attempted to go around but hit a pickup truck that was parked in the parking lot at the end and to the right of runway 19.Incident 20080707838459IBeech G35 · Willapa Harbor, WA(-23) Performed on site inspection coordinated with NTSB. Pilot told FAA engine failed at 6K feet cruise altitude. Pilot declared emergency and landed gear up in field. One pilot and two passengers exited aircraft no injuries. On site investigation revealed…Incident 20080706854589IBoeing 757251 · Tampa, FLWhile passing through FL180, during the descent for a landing at Tampa, Florida, the aircrew heard a loud bang and the radar system failed. It was an otherwise normal approach to landing, in clear sky, with no turbulence. The aircraft continued to handle…Incident 20080706847219IYaklev YAK52 · Middleton, WI(-23) Upon entering the traffic pattern for runway 28, at C29, the pilot stated that he ran all mental checklists and thought he had placed the gear handle in the down position; as he normally does this at specific points within the traffic pattern. The…Accident 20080706843339ABeech C23 · Chicago/Schaum, IL(-23) On July 6, 2008, at about 1400 CDT, [privacy data omitted] was pilot-in-command of Beech C-23, N6715X, landing at Schaumburg, IL after previously departing wheeling, Illinois. The pilot reported that upon landing the gusty and variable wind conditions…Accident 20080706841449APiper PA28161 · Seneca, OR(-23) Pilot reports that he had operated the aircraft from mmv to 7OR8 under VMC with no events. Weather was good at 70R8 at the time of arrival with winds at 310 degrees at 10 knots, gusting to 16 knots, altimeter at 30.14 inches. OAT unknown. Density…Accident 20080706840999ACessna 337G · Point Lookout, MO(-23) The aircraft had been parked outside in rainy weather for three days prior to the flight. The pilot stated that as part of his preflight inspection he noted the presence of water in the fuel samples but repeatedly sumped the fuel drains until they were…Accident 20080706840709AAyres S2R600 · Benson, MNAs the pilot was spraying a wheat field, he failed to see the two seats of power lines at the beginning of the field. The pilot stated he saw the first two lines, but did not see the second set of lines. The main landing gear caught on the wire, tearing a…Accident 20080706840139APiper PA28140 · Green River, UT(-23) On July 6, 2008 at or around 12:40 pm local time, N7360J, a Piper PA-28-140, piloted by [privacy data omitted] crashed approximately 45 miles north of Green River, UT along the Green River while attempting a precautionary landing. The pilot sustained…Accident 20080706840019ALancar LC41550FG · Hailey, ID(-23) The pilot stated while taxiing north on taxiway bravo for a runway 13 departure, the aircraft began to drift to the left. The pilot stated he attempted to correct by applying right brake and felt no response. The pilot stated he then realized the right…Incident 20080706839599ICessna A188B · Miles City, MT(-23) On July 6, 2008, at 1335 MDT, a ccessna CE-188-B, N4890R, registered to [privacy data omitted], and piloted by [privacy data omitted] touched down at Miles City airport, (mls) on runway 12, uponlanding the aircraft was spun around by a gust of wind and…Incident 20080706838449IMaule M7235C · Las Vegas, NV(-23) The airport ATIS was reporting a wing speed of 19 knots with gusts to 25 knots. The landing runway would result in a 10 degree crosswing from the left. After a normal approach to landing with 12 degrees of flaps, the PIC stated that the left main…Accident 20080705855249AAyres S2R · Colquitt, GA(-23) During application of agricultural chemicals (mepex and vidrin), while making west-east run, on pull-up at east end of field to 300', puff of white smoke from exhaust, engine lost power. Pilot attempted to land on field. Impacted about 45 degree angle.…Incident 20080705847529IPiper PA34220T · Grayslake, IL(-23) Entered left downwind for runway 09. Normal pattern. After passing over threshold at the normal airspeed of 85 knots. Aircraft sank. Aircraft came down hard, bounced on the main gear, maintained directional control, bounced the second time on the main…Incident 20080705847229IMooney M20C · Huntley, IL(-23) On July 5, 2008 at approximately 1000 CDT, N7872V intended to depart the Landings Condominium from runway 13. During takeoff roll, just prior to rotation between 65 and 70 mph, the landing gear johnson bar came out of its detent, followed by the landing…Accident 20080705843949ARV7 · Neptune, NJ(-23) The aircraft departed monmouth executive airport at approximately 1250 hours on July 5, 2008 for a local flight, at approximately 1850 hours it was seen by several people descending vertical into the shark river. The engine was reported to be screaming…Accident 20080705843729ACessna 172F · La Verne, CA(-23) N8881U was flown by 3 renters on the day of the accident. Pilot #1 took the aircraft for a 1.8 hour cross country flight after fueling the aircraft with 5.4 gallons of fuel at 08:33 am. Pilot #2 took the aircraft for a 2.4 hour cross country flight…Accident 20080705843549AAmtr GENESIS2 · Beloit, WI(-23) On July 5, 2008 at 1515 CDT an ab sportine aviacija genesis 2 glider registered to [privacy data omitted] of new berlin, Wisconsin colided with a tow cart while landing at the Beloit, Wisconsin airport/glider port. The aircraft was landing on hard…Accident 20080705843469APiper J3C65 · Chicago/Lake I, IL(-23) Pilot made a wheel landing on runway 8. The crossed the threshold at 50-60 mph. After 2 seconds the pilot allowed the tailwheel to settle to the runway. The airplane then veered right.Accident 20080705843429AAmtr RV8 · Valera, TX(-23) While conducting low passes over a crowd of 1,200 people gathered at a sw Texas ranch for a 4th of July bbq, the pilot completed his 3rd pass with a steep pull-up intending a course reversal, the aircraft appears to have stalled, rolled left and entered…Accident 20080705843359ACessna 150G · Grand Rapids, MN(-23) Pilot was attempting to land with cross winds gusting between 24 and 29 mph. Pilot stated that he lost control of the aircraft and was blown off the side of the runway. The aircraft's right wing contacted the ground, the left main gear leg and nose…Incident 20080705842989ICessna 172M · Biddeford, MEOn landing runway 24, aircraft porpoised, landing hard on the nose wheel. Nose tire blew, wheel assembly was damaged and one propeller tip struck the runway. Approx 2 inches of one propeller blade was missing.Incident 20080705842259IPiper PA31325 · Wahoo, NE(-23) The PIC was performing touch and go takeoffs and landings at the Wahoo airport in Wahoo, Nebraska. On the third landing, the before landing checklist was used, but the PIC failed to verify three green lights on the gear down indicator. In the landing…Accident 20080705841839AMooney M20K · Howell, MI(-23) Aircraft was departing runway 13 at kozw, at approximately 60 knots a male whitetail deer ran into path of aircraft and was struck with prop and left wing.Accident 20080705841119ACessna 152 · Rossville, TN(-23) On July 5, 2008, at 1422 central daylight time, a Cessna 152, N5372B, operated by air venture flight center, was destroyed following a steep descent and collision with terrain after departing cruise flight near Rossville, Tennessee. The certificated…Incident 20080705840849IPiper PA28236 · Camdenton, MO(-23) The pilot induced a hard landing of his aircraft approximately fifty feet short of the runway tearing off the nose gear assembly prior to skidding 1000 feet down the runway.Accident 20080705839879ARobsin R44RAVENII · Spring Branch, TX(-23) On July 5, 2008, at approximately 1600 CDT, a Robinson R44 helicopter, N804DF, sustained substantial damage when it landed hard after loss of tail rotor effectiveness. The commercial pilot and front seat passenger were not injured. The back seat…Incident 20080705839569IPiper PA34200T · Nashville, TN(-23)N3776Q call bna ATCT over jwn and requested landing at bna. The pilot stated that the nose gear would not come down. An alert 2 was called. The aircraft landed on runway 20C with the nose gear up at 2024Z (1524 CDT). The aircraft suffered visible damage…Incident 20080705839549IElizabethtown, KY(-23) On July 5, 2008 sport parachute operations were being conducted at Addington Field, (ekx), Elizabethtown, KY at 2020Z, parachutitst [privacy data omitted] was fatally injured. Witnessed to the event state that [privacy data omitted] opened the chute at…Incident 20080705839229ICessna 150M · San Diego, CA(-23) N6220K, a Cessna 150M made an emergency landing on helicopter spot nr 2 at Miramar Mcas (nkx) due to a rough running engine, after landing the pilot discovered the nr 4 connecting rod had gone thru the engine cse. Pilot and passenger onboard no injuries…Accident 20080705839009ACessna 195 · Johnstown, NY(-23) Pilot took off from saratoga springs airport and flew to Johnstown/Fulton County Airport. Upon attempting to stop after landing, the aircraft loss control and flipped over causing substantial damage. Pilot was not injured. The aircraft showed no signs…Incident 20080705838509IBeech 300BEECH · Georgetown, KY(-23) Pilot could not control aircraft to make right turn and enter the runway. Aircraft exited taxiway and the left propeller hit a taxiway light and runway sign before coming to a stop.Incident 20080705835269IEaster EAAMTD1 · Levelland, TX(-23) During landing the pilot felt a bump and executed a go-around. The pilot requested another aircraft conduct a visual check of his landing gear. The other pilot, [privacy data omitted], reported his right gear was broken the pilot landed on the left gear…Accident 20080704855259AStolac UC1 · Bunnell, FL(-23) On July 4, 2008 at approximately 1145 EDT, a stol UC-1 amphibious aircraft, registration number N9509U, s/n 021 piloted by [privacy data omitted] giving instruction of student pilot [privacy data omitted] was practicing glassy water landings at dead…Incident 20080704847009ICessna U206B · Taylorville, IL(-23) Incident number igl 1920080028. During a first time jump, a parachutist had a malfunctioning main canopy and cut away too low to achieve a full reserve canopy. The parachutist impacted the ground in a bean field near the airport. The jumper did not…Incident 20080704846999IAmtr Ctsw · Milaca, MN(-23) The pilot lowered the nose of the aircraft to compensate for floating down the runway, in an attempted to land. As the aircraft continued to float down the runway the pilot applied full power to go around. The propeller struck the runway, as a result…Incident 20080704846849IStoess Powrachutepc · Jerseyville, IL(-23) While conducting a takeoff maneuver from a private field, the pilot-in-command of N308PC, a powered parachute, came into contact with an all terrain vehicle (atv) which resulted in minor damage to the aircraft when the aircraft fell onto its side as a…Incident 20080704845449IPerris, CA1. Parachutist [privacy data omitted] was fatally injured following a partial deployment of main canopy. 2. Parachutist had in excess of 13,000 jumps and record of training was not available. 3. Club affiliation was uncertain. 4. Equipment: harness/container:…Accident 20080704843249ARobsin R44RAVENII · Wedron, IL(-23) On July 4, 2008, at about 1820 CDT, at Wedron, Illinois, [privacy data omitted] was pilot-in-command of Robinson R-44, N31138, providing a sight-seeing flight with 3 passengers. Shortly after takeoff he encountered the fox river and began a flight over…Accident 20080704841059APiper PA22 · Colorado Sprin, CO(-23)On 07/04/2008 a Piper PA-20 while attempting to land at Meadow Lake Airport had the left main landing gear fail on landing, followed by groundloop damaging the left wing and prop. Also right aft lower longeron bent near tailwheel spring, also tailwheel…Accident 20080704840719ACessna 150J · Seal Beach, CA(-23) Pilot departed compton woodley airport (cpm) with full fuel load in the wings 18 gallons each wing 36 gallons total. Few approximately 1 hour and 45 minutes performing banner towing operations without changing fuel tanks. Engine quit and the aircraft…Accident 20080704840619AMooney M20M · Elbert, CO(-23) On July 4, 2008, N17RA, Mooney, model M20M, piloted by [privacy data omitted]. At 1748Z attempted to land at Kelly airpark, 9CO15), CO. The pilot tried to go around and the engine failed to develop power and made a hard landing. The aircraft sustained…Incident 20080704840379ICessna 172S · Renton, WA(-23) On 07/04/08, N97PD owned by Boeing flying club association and piloted by [privacy data omitted] had a propeller strike during landing while touch and go landings at Renton airport. No injuries to the pilot.Accident 20080704839749AHughes 269C1 · Livermore, CA(-23) The eye witness said the helicopter was flying "very low and very slow," along I-680 south bound so he was able to keep speed with it in his fire department suv. At one point, with the helicopter right above him, anderson rolled down his window and…Incident 20080704838529IPiper J3C65 · Green Creek, NJ(-23) The incident happened at 2200 (local) on 7/4/2008. The aircraft departed paramount airfield (JY04) at approximately 1000 (local) to conduct banner tow operations. [privacy data omitted] Stated the engine lost oil pressure and seized up which caused him…Incident 20080703856299ICessna 525B · Destin, FLN92MA conducted a normal approach and landing at the Destin, Florida (kdts) airport. Both pilot and copilot confirmed speeds and approach were normal. As the aircraft started to commence braking, it began drifting off to the left side of the runway with very…