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 20090925017299ACessna 182T · Parowan, UT(-23) During first landing attempt pilot cut the final to short and decided to abort landing. Pilot extended the final on second attempt aircraft touched down with full flaps and bounced about four feet into the air and bounced a second time, pilot still had…Accident 20090924050829APiper PA-32-260 · Troy, MIAircraft departed runway 09. Shortly after rotation engine failed due to apparent fuel starvation. Aircraft landed in a walmart parking lot adjacent to northeast corner of runway 09. Fuel system integrity was verified. Engine operation was normal by post…Incident 20090924049959IMooney M20J · Lakewood, NJ[privacy data omitted] CFI cert #[privacy data omitted] was providing training to [privacy data omitted]in their club aircraft practing take off and landings. On the 7th landing they forgot to place the landing gear in the down position and landed gear up.…Accident 20090924025609APiper PA-20 · AK[privacy data omitted] Attempted to leave hunting camp at a small private strip with ice and snow covering the ground. On takeoff the aircraft hit a large dip in the runway and became airborne, this sent the aircraft to the side of the strip, struck the…Accident 20090924020089ACessna 182Q · Houma, LAN96894 called the Houma, LA. Tower for taxi instructions, the tower instructed N96894 to taxi to runway 18 and advised the pilot the airport was IFR with and overcast ceiling at 300 feet and visibility seven miles. The pilot requested to depart the airport…Accident 20090924018339ACessna 182 · Lucille, IDThe aircraft landed at pittsburg airstrip at approximately 1200 on 09/24/2009. The rollout was normal until the acft reached the intersection of runways 12 and 15. There was a hump there that lifted the gear and made braking uneffective causing the acft to…Accident 20090924017419AAmtr Challengerii · Lumberton, MS(-23) The pilot flew over the runway and made a left bank approximately 1/4 of a mile west of the runway. During the left bank the aircraft descended and hit several branches in a nearby sweet gum tree, then struck the trunk of an oak tree. The oak tree was…Incident 20090923050099IPiper PA-32R-300 · Okeechobee, FLPilot stated that on final approach he forgot to lower the landing gearAccident 20090923049859AC A Tecnam P2002 Sierr · Enterprise, ALOn September 23, 2009 at Enterprise, Alabama's airport, edn, N426TS Tecnam P2002S, the pilot was landing his aircraft during his second solo flight. Pilot lost control of aircraft upon landing. Aircraft departed the left side of the runway impacting tree line…Incident 20090923049839IBeech A36 · Louisa, VAUpon landing at Louisa (lku) aircraft impacted deer on runway.Incident 20090923018449ICessna 310K · Bridgeport, TXOn September 23, 2009, at approximately 1300 local time, pilot in command Mr. Eric dale vassberg, onboard Cessna, CE-310K, N7091L, with 3 other occupants, landed on runway 35 at Bridgeport airport (kxbp). After landing and slowing down, the right main gear…Accident 20090923018329AFrazie Tangent · Nampa, IDDuring high speed taxi test on runway 11, N72TZ a frazier allen Tangent, and aircraft of the pilots own design and construction, the pilot lost control of the aircraft, the aircraft pitched up at about a 45 degree angle and climbed to about 125 ft. at this…Accident 20090923018209ACessna T210N · Hilltop Lakes, TXPilot attempted landing on an unlit private runway. Pilot made right turn hit trees to the right of the runway crashing into an unoccupied house. Pilot was fatally wounded. Aircraft and house were destroyed.Accident 20090923017739ABell 407 · Alliance, TX(-23) The flight instructor was operating the controls of the helicopter while demonstrating a simulated fadec emergency proedure, with the fadec control system in the manual position. While the fadec is in the manual position, engine RPM must be controlled…Accident 20090922049929ARittal Alfr Glastar · Bethel, AKThe pilot flew to a hunting site approximately sixty five miles east of Bethel on Cripple Creek which flows north into salmon river. The airstrip is not an improved or published airport, although it is used by other aircraft. On approach to landing the pilot…Incident 20090922022219IMooney M20C · Glasgow, KYUpon landing in Glasgow, Kentucky (glw) the landing gear control stick ("johnson bar") popped out of its detent causing a landing gear collapse and subsequent belly landing. The damage to the propeller and belly skin were classified as minor. The flight was…Accident 20090922021349ACessna 402B · Omaha, NEPilot of Cessna 402B, N1048, began taxing from fright ramp and became blinded by the sun. Subsequently, impacting a parked SA227AT. The right engine on the Cessna was damaged as was the nose cone on the SA227AT.Accident 20090922019379AAgusta A109K2 · Page, AZThe aircraft ran out of fuel and made a forced landing in the baseball field at Page high school, located in Page, AZ. Block 22- omniflight operates all flights as 135 flights. However, there were no revenue passengers on board this repositioning flight.Accident 20090922018249APiper PA12 · Fulton, MOThe non-instrument rated pilot flew from VMC into IMC in an airplane that did not have gyroscopic attitude or directional instruments. There were no witnesses to the actual crash but examination of the wreckage indicated it impacted the ground in a near…Accident 20090921049749APiper PA-22 · Cordova, AKThe pilot stated he departed mri on 09/19/2009 and landed on the beach at patton bay on montague island. At 1400 hours on 09/21/2009, the pilot prepared for departure with one passenger and gear on board the aircraft. He stated he walked the beach over the…Incident 20090921049719ICessna 150G · Littleton, NHAircraft departed seaplane base at turner, Maine at 1530 local. Landed at partridge lake in Littleton, NH at 1628 EDT. After landing, the pilot elected to taxi on the step. The pilot attempted a left turn, aircraft leaned to the right and right wing impacted…Incident 20090921018679ICessna 525A · Olathe, KSAccording to PIC, he landed on rwy 18 near the touchdown zone marker and applied brakes but they were ineffective. With 1,000' remaining, he observed 80 KTS IAS. The aircraft continued off the end of the rwy, struck two reil's, and traveled approximately 530…Accident 20090920050629APiper PA32R-301T · Unincorporated, FLPilot of N2467Y called maday and reported a "fire in the engine", and moments later "we have smoke in the cockpit". With in 60 seconds the pilot reported, "can see some fire coming off of the nose". Pilot said he intended to fly to kfxe. This airport is 25…Accident 20090920049659APatrick Dan Kolb MK III · North Stoningto, CTThe following statement is from the police report and from a telephone conversation with the pilot: at approximately 10:30 or 10:45, the pilot was flying and making his final approach at the wychwood airport (CT48). His flap setting was at 20 degrees and he…Incident 20090920049619IPiper PA-12 · Jackman, MEWhile attempting to land at Newton Field, Jackman, Maine pilot neglected to lower the landing gear. Pilot realized error and initiated a "go-around". Due to engine torque aircraft rolled slightly left at which time the left float contacted the runway causing…Incident 20090920049589ICessna P210N · Johns Island, SCAircraft propeller struck temporary barrier on taxi way in route to runway. Aircraft returned to ramp due to propeller damage. Damage was restricted to propeller tips. No injuries.Accident 20090920025559ARyan Navion · Fire Island, NYDuring cruise flight the PIC states he turned on the fuel boost pump and switched fuel tanks from main to auxillary when the engine quit. The pilot then switched back to the main tank and the engine failed to restart. The PIC states he confirmed fuel boost…Accident 20090920021729ARobsin R44RAVENII · Ramona, CAOn September 20, 2009, about 1440 pacific daylight time, a Robinson R44 ii, N4174P, collided with terrain during a forced landing near valley center, California. The pilot was operating the helicopter under the provision of 14 code of federal regulations part…Incident 20090920021559IBeech V35 · Nacogdoches, TXAircraft departed gladewater, TX(07F) with a fuel stop at henderson, TX(rfi) with a final destination of beaumont, TX (bpt). Climbing out of henderson, TX at approximately 6,000FT a pecking sound was heard along with some vibration for approximately 5 seconds…Incident 20090920021159IPiper PA24250 · Houston, TXJust prior to landing on runway 17R, pilot heard metal dragging on pavement. Pilot raised the nose of the aircraft and added power. A go around was initiated and the pilot then flew by the control tower to see if the gear appeared to be down and locked. Tower…Accident 20090920018189AAimm AMT200S · Wheeling, WVThe pilot stated that the cowling gasket came loose allowing outside air to enter the cockpit. The outside air rushing into the cockpit and blowing on to the pilot's face distracted him. Upon landing downwind on rw 03, the aircraft touched down slightly left…Accident 20090920017849ARobsin R22BETAWitnesses (father & son) stated that the aircraft seemed to be practicing; a loud noise was heard not usual for the aircraft; (witnesses frequently observe this type aircraft in the area); the aircraft made a quick rotational turn, nosed down, wobbled,…Incident 20090920017819IBoeing 737824 · Denver, CO(-23) 9/20/09 - Continental flt 229 departed Denver, CO (den), enroute to newark, NJ (ewr), at 0806 MDT (1406Z). Report stated "on final apch to den, rptd flt ctrl prob & overweight, lndd den 1438Z w/o further incident." There were no injuries in this…Incident 20090920017619IBlanca 1730A · Odessa, TX(-23) On September 20,, 2009 at approximately 1545 CDT, the landing gear collapsed on N8234R, a Bellanca 17-30A, upon landing roll out on runway 02, at Odessa Schlemeyer (odo) in Odessa, Texas. The aircraft slide for approximately 800 feet down the center of…Accident 20090919051209ACessna 182Q · Montauk, NYDuring landing at mtp airport on runway 24, pilot touched down approcimately halfway down the runway. During the rollout pilot was unable to stop airplane and rolled off the end of runway 24. Airplane exited ruunway 24 striking a tree with the left wing.…Accident 20090919050849ABeech A36 · Fairmont, WVAccording to the pilot in an interview, aborted takeoff on rwy 23 when he noticed that he did not have the altitude to clear the embankment at the end of the runway. Pilot stated that aircraft appeared to accelerate normal. Airplane maximum certified take off…Accident 20090919049899AAviat Aircr A-1C · Princeton, MNApproach seemed normal to pilot. Touch down seemed normal. Prior to the tail dropping aircraft began oscillating left and right, moving to the right hand side of the runway. The right gear then transitioned off the asphalt runway and pivoted to the right. The…Incident 20090919049519IBeech S35 · Crystal River, FLFlight instructor (pilot-in-command) and "student," a private pilot building complex airplane time towards a commercial certificate, were utilizing runway 9 at Crystal River Airport with the intent of doing several touch and go's. after the first landing at…Accident 20090919025629ACessna 172 · SCAircraft crashed into lake russell near loundesville, SC. There were 2 people on board that sustained fatal injuries. The aircraft was destroyed.Incident 20090919021569ICessna 182N · Ft Worth, TXOn September 19, 2009, at approximately 1245 local time, pilot in command Mr. Sandeep sharma, on board Cessna, CE-182N, N92203, was approaching arlington airport (gky), Texas. Form 8020-26, issued from the fort Worth artc center, and signed by facility…Accident 20090919018129AAmtr CASSUTT3M · Reno, NVDuring the Reno air race, cassutt 3M lost engine power and landed short of Reno Stead (4SD) runway 14. The aircraft received substantial damage and the pilot suffered a broken back requiring surgery. Examination of the engine revealed #2 cylinder rod had…Incident 20090919017559IPiper PA34200 · Denton, TX(-23) On September 19, 2009, at approximately 1800 local time, on board PA-34-200, N852AT, pilot in command and flight instructor [privacy data omitted], instructed [privacy data omitted] during a landing at Denton airport (dto) after five touch and go…Accident 20090918049949AMooney Airc M20K · Farmville, VAImmediately after touchdown on runway 21 at Farmville, Virginia, the aircraft engine surged and the aircraft veered to the left of the runway. The aircraft continued across the grass and across a shallow ditch, struck the airport VASI, and struck a hedgerow…Accident 20090918049699AConstruccio C-212-CC · Savoonga, AKThe pilots stated that they touched down on runway 05 in Savoonga and the aircraft began to drift to the right. The captain added power on the right engine to correct. The aircraft then drifted to the right again and the pilots were unable to correct the…Accident 20090918025619APiper PA-18-125 · Nabesna, AKPilot was departing river bar with one passenger. Winds were light but shifting. After liftoff pilot realized that wind had shifted and was now a tailwind. Aircraft began to settle. Pilot realized the aircraft was not going to clear obstacles ahead and…Accident 20090918022139AMclish B85C · Coffeyville, KSOn September 18, 2009 this office received a call that a funk B85C, N81167, had caught fire and burned at Coffeyville, Kansas. The pilot, jon schroeder, stated he had the fuselage tank refueled and decided to fly a quick trip around the local area and give…Incident 20090918020439IAmtr Tangoii · Reno, NVAircraft contacted runway nosewheel first with subsequent failure of the nose gear.Incident 20090918018469IPiagio P180 · Santa Ana, CAPiaggio P-180, N780CA, enroute from st. george, UT, to Santa Ana, CA, lost aft cargo door at 13,000 feet, approximately 40 miles north of hector, CA. Aircraft landed safely at sna without further incident. No reported air or ground injuries.Incident 20090918018349ILake Elsinore, CA1) Name of jumper: [privacy data omitted]. 2) experience and training of jumper: novice (spain (military instructor)[privacy data omitted]. 3) club affiliation:bpa 4)type of parachutes and packing records: performance design navigator two sixty; performance…Accident 20090918018239APiper PA28180 · Sibley, IAUpon landing on runway 35, the pilot determined that the aircraft would not stop prior to reaching the end of the runway due to excessive speed. Touchdown occurred at approximately 1500 feet down the 3000 foot runway at approximately 105 knots, with one notch…