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 20090421005569IPiper PA34200T · Lago Vista, TX(-23) On April 21, 2009 [privacy data omitted] acted as pilot in command his aircraft a Piper seneca ii registration number N9528C after finishing an annual inspection. During the flight he lost all electrical power and decided to land the aircraft. During…Accident 20090421004449ACessna 208 · Frederick, MD(-23) On roll out at fdk after a short flight from okv, the pilot heard a pop and observed the engine starting to spool down. He then turned off the runway and stopped when he saw smoke coming from the engine area and thought it was residual fuel. He then…Accident 20090420009679ACessna 152 · Carlsbad, CA(-23) Pilot had been doing pattern work (touch and go landings) for over an hour. On last takeoff initial climb and crosswind leg were uneventful. Aircraft was approximately 800 feet indicated altitude on a right downwind for runway 24 when pilot experienced…Incident 20090420007369IPiper PA24 · Pahokee, FL(-23) N5748P landed with the landing gear retracted on runway 17 at phk. Marks on the runway indicated that the bottom of the aircraft's fuselage made the initial contact with the runway approximately 1200 feet beyond the runway threshold. The aircraft then…Accident 20090420006849ACessna 172P · Livermore, CA(-23) On 04/20/2009, at 08:30 PDT at the Livermore (lvk) airport, during approach to the Livermore airport on runway 25R, the pilot was traveling about 70 to 75 knots on final. Upon flaring the aircraft for landing, the main landing gear touched down and…Accident 20090420005879AAmtr Titantornado · Slaughter, LA(-23) Aircraft departed from A&P airpark (ls 77) in Slaughter, LA en route to jonesville, LA (L32). The student pilot made two practice runs prior to departure, and stayed in the pattern a approximately 700 feet. Aircraft was ocillating (moving up and…Incident 20090420005629IAmtr Challengerii · Enumclaw, WA(-23) On 04/20/2009 at approximately 1920 local time [privacy data omitted] the pilot of N901GH an experimental aircraft. Departed Enumclaw municipal airport. After reaching an altitude of about 2000 feet MSL the pilot lost control of the aircraft elevator.…Accident 20090420005489AEubank ZENITH250 · Point Lookout, MO(-23) The aircraft owner and pilot in command, [privacy data omitted], allowed [privacy data omitted], a private pilot, to fly the aircraft from the left seat and land it on runway 29 at M. Graham Clark - Taney County Airport (plk) in Point Lookout, MO.…Accident 20090420004829AAmtr Varieze · Santa Teresa, NM(-23) On 04/20/2009, at approximately 1555 MDT, N77JM, an experimental homebuilt Varieze, departed Santa Teresa municipal airport (K5T6) enroute to pensacola, FL. After rotation, approximately 20-30 feet in the air, the canopy popped open. At that time, the…Accident 20090420004609ADhav DHC8202 · Phoenix, AZ(-23) Air suttle flt 2957, struck a ground power unit with right engine propeller while taxiing into gate B24 at Phoenix, AZ.Accident 20090420004459AAmcnlg AL3 · Mc Kinney, TX(-23) Aircraft N273MS landed at Collin county regional airport after performing "touch and goes" when the aircraft tail section rose up and the aircraft nosed over and came to rest upside down.Accident 20090420003789ACessna 210 · Moab, UT(-23) Pilot failed to extend landing gear during normal approach to canyonlands, Utah, runway 03. Aircraft landed on centerline and decelerated straight ahead wings level on the aircrafts belly. Aircraft was evacuated with no injuries to crew or passengers.…Accident 20090420003759AEnstrm 280FX · Erie, CO(-23) During training in preparation for a private pilot certificate, instructor initiated a simulated power failure. Normal autorotational descent was accomplished. Power recovery was initiated by increasing throttle. Engine did not develop full power. It…Incident 20090419046959ITaylorcraft BL-65 · Talkeetna, AKPilot made statement;on Sunday, April 19th, I made a flight from willow to denali national park. On my return trip the same day I landed in the Talkeetna mountains. When I landed, the snow was harder than I expected, and my Taylorcraft (27740) did not stop…Accident 20090419016239AExtra EA300 · Santa Barbara, CA(-23) On April 19, 2009, N101PK an Extra EA-300 was performing aerobatic maneuvers two miles off shore of el capitain state beach. At 1725 PST. N101PK was lost off the Santa Barbara approach radar. A witness reproted seeing an aircraft diving into the ocean…Incident 20090419007349IMooney M20R · Ocala, FLPilot forgot to put the landing gear in the down position and landed gear up.Incident 20090419007329IAmtr Skyranger · Winter Haven, FL(-23) Aircraft took off, engine ran for approx 2 minutes then stalled, engine was re-started and ran for another 20-30 seconds and stalled again. Engine re-started and ran for about 8 seconds then stalled again, pilot landed aircraft on road without incidnet.…Incident 20090419005399ISonex Waiex · Chehalis, WA(-23) The pilot was taking N67YX an experimental aircraft for its first flight after he completed building it. About two minutes into the flight the engine started to run rough. The condition continued to worsen. The pilot then headed for Chehalis-Centralia…Accident 20090419004969AAmtr Searey · Littleton, NC(-23) Pilot taking wife on pleasure flight. On approach to water landing, pilot extended landing gear. On touchdown, extended landing gear caused airplane to nose over, then submerge ending up inverted below the surface. Pilot was able to use emergency exit…Incident 20090419003419IPiper PA28140 · Granby, CO(-23) During a touch and go operation on rwy 27 at kgnb, after the landing, pilot applied full power for takeoff. Aircraft veered left and left main departed runway surface. In an attempt to get back on runway, aircraft skidded and veered right, crossed…Incident 20090419003039IPiper PA22150 · Missoula, MT(-23)On April 19, 2009, at 1430 MDT, a Piper PA-22-150, N5741D, registered to and piloted by [privacy data omitted] ground looped the aircraft at Missoula, Montana while on a personal part 91 flight. Visual meterological conditions prevaled at the time of the…Incident 20090418010799IMooney M20F · Mitchellville, MD(-23) While repositioning the aircraft, the pilot slid off taxiway due to mud and the propeller struck the ground.Incident 20090418009439IGrtlks 2T1A2 · Livermore, CA(-23) Upon landing at lvk, 25L, touching down on all three wheels and the engine at idle, the pilot passed the second taxiway, attempted to get off the heel brakes to roll to the next taxiway. The brakes did not come off equally. Aircaft begun to turn right…Accident 20090418008969ATcraft BC12D · Southbridge, MA(-23) N96552, a Taylorcraft BC12-D departed runway 2 to the left during takeoff. The aircraft struck a runway light continued into the grass with the propeller contacting the ground. The aircraft came to rest in an inverted position with no injuries to the…Accident 20090418008919ACessna 305F · Embdem, MA(-23) Pilot landed long on 1400' grass strip in embden, Maine. Aircraft rolled out onto newly extended portion of runway and right landing gear sank into mud. The right landing gear became detached from aircraft and the aircraft nose over coming to rest…Accident 20090418008699ABoeing 737724 · Mc Allen, TXAircraft departed iah enroute to mfe, upon descent into mfe @280 knots and approx 1000 VSI, FL 200 aircraft entered a line of precipitation about 5-10 NM wide, aircraft entered into a cloud formation and encountered severe turbulence for about 15 seconds,…Incident 20090418008649IEaster Prescottpush · Columbus, OH(-23) The pilot stated the following, while performing a test flight, specifically slow flight maneuvers, the gear was extended to verify the flight characteristic of the aircraft. After the gear was extended, only the left main gear indication was green. I…Incident 20090418008349IAmtr SPORTSMAN22 · Greenville, MI(-23) Right main landing gear damaged while attempting to land at Greenville, Michigan.Accident 20090418007139ABbavia 7ECA · San Jose, CA(-23) Aircraft impacted rugged terrain straight down and came to rest in vertical position.Accident 20090418006419AAmtr Firestarii · Church Hill, TN(-23) Pilot departed hks around 1220 direct to 77TN with arrival at 1240 hours local. Pilot was in a tandem flight of two, following another kolb firestar. Pilot stated that on approach into 77TN out of 3000' AGL he attempted a landing approximmately 3…Incident 20090418005759ICessna 182 · Copenhaven, ID(-23) [privacy data omitted] was moving N6466A, a Cessna 182 from mackay bar airport to the Copenhaven airport, about one mile south west of mackay bar airport. He was landing down stream. Upon touchdown he applied the brakes and found that the braking action…Incident 20090418005289IMaule M4210 · Pawtucket, RI(-23) While landing runway 33 at north central airport (sfz) rhode island, aircraft ground looped and struck the right wing tip, propeller, and the right main landing gear.Accident 20090418004469AAmtr Kitfox · Dubre, KY(-23) On April 18, 2009, at 1633 central daylight time, an experimental amateur-built, gladstone Kitfox, N191KF, registered to a private owner, operating as a title 14 code of federal regulations part 91 personal flight, collided with the ground while…Accident 20090417013459AAlexan SPORTSMANGS2 · El Dorado Hill, CAAirplane crashed and burned. The pilot was killed. Their were no passengers. This report to be updated as needed. The investigation not completed at this time. Amendment - aircraft crashed into residential area for unknown reasons. Fire destroyed aircraft and…Incident 20090417009489ILear 31 · Boca Raton, FL(-23) This aircraft N818LJ had departed Boca Raton Airport (kbct) and landed at ft. lauderdale international airport (kfll) where the crew picked up passengers. After departing (kfll) approximately 20 minutes into the flight at 35,000 ft the left hand engine…Incident 20090417005459IWilson SQ2 · Lebanon, MO(-23) Approaching Floyd w Jones airport (lbo) in Lebanon, Missouri, while in a descent, the engine began to run rough so the pilot applied carb heat and the engine began to run somewhat smoother. As he began to prepare for an arrival at the airport, he pushed…Accident 20090417003769ABrinke Biplane · Caldwell, ID(-23) Pilot stated that he elected to land aircraft while on its second evaluation flight after noticing an unexplained vibration that he later thought was caused by a loose flying wire on the inboard left wing. During the wheel landing, he touched down at a…Incident 20090417003399IPiper PA34200 · La Verne, CA(-23) On the 17th of April 2009, a flight instructor, flying a Piper PA-34-200, N60YX, was preparing his student for a commercial multi-engine/instrument check-ride at the Brackett airport (poc), pomona, California. The pilot indicated that the student had…Accident 20090416025159ACessna 152 · Talkeetna, AKAccording to the pilot, the weather was good and the winds were calm. The pilot was sightseeing and flew up the kahiltna glacier. He was maneuvering the aircraft for a low pass over the ski strip at the denali base camp at about 150 feet AGL. According to the…Incident 20090416009169IAmtr CH601XL · Jacksonville, FL(-23) On April 16, 2009 at approximately 0930 EDT, a zodiac 601XL light sport aircraft, registration number 454BB, s/n 601-054S, piloted by [privacy data omitted] was touch and go instruction to a student at heg in Jacksonville, Florida. Upon landing for the…Accident 20090416008319ACirrus SR20 · Osceola, WI(-23) Student pilot was on first away from airport solo. Planned solo practice flight was for t.o. and landings at anoka, MN (ane) to cambridge, MN (kcbg), osceloa, WI (koeo) and return to ane. Departed ane 11:30, departed cbg 12:05 with uneventful landings…Incident 20090416007299IPiper PA44180 · Hollywood, FL(-23) On April 16, 2009, the miami air traffic control center reported that aircraft N3074P, serial number 44-7995236, left main landing gear collapse during landng roll-out at the North Perry Airport (hwo). The aircraft left wing came to rest on the grass…Accident 20090416006439ACessna 152 · Trenton, FL(-23) A/c N-64988 departed ormond beach, FL. At approx. 8:30AM on x-country to cross city, FL., departed cross city, FL. At approx 10:15 to return to ormond beach, FL. At approx 2000 ft. engine lost about 300 to 400 RPM, pilot checked mags and pull carb heat…Incident 20090416005649IPiper PA28140 · Richmond, KY(-23) While on an instructional flight, PA-28-140, N6709W, piloted by a student pilot and flight instructor [privacy data omitted] exited the right side of runway 36 at the Richmond-Madison county airport (K139) in Richmond, KY, resulting in minor damage to…Accident 20090416004719AMaule M5235C · Los Angeles, CA(-23) [privacy data omitted] was manipulating the flight controls while landing N9219E on runway 30 at Whiteman Airport when the aircraft bounced on the runway and went back in the air in a nose high attitude. The aircraft came back down on the runway and…Accident 20090416004599AAmtr EXEC162F · Chandler, AZ(-23) On April 16, 2009, around 0822 mountain standard time, experimental rotorcraft, better burn LLC, exec 162F, N333ST rolled over to the right side while touching down on the taxiway at Chandler Municipal Airport in Chandler, Arizona. The experimental…Incident 20090415046929IDehavilland DHC-2 MK. I · Ketchikan, AKCheck airman struck a submerged reef while demonstrating step taxiIncident 20090415015059IConaer LA4200 · Orlando, FL(-23) After landing on runway 7, at Orlando Executive Airport (orl), the right main gear collapsed while taxiing to the ramp area.Accident 20090415009059AAmtr Tbirdii · Carlock, IL(-23) [privacy data omitted] was taking off on a privately owned bean field in a light sport aircraft when he struck a cameraman who was filming the takeoff. The cameraman, [privacy data omitted] received serious injuries as a result of the accident. [privacy…Incident 20090415005729IRoserh A4-C · Houston, TX(-23) After a normal landing and prior to departing the runway, a gust of wind caused the aircraft to start a ground loop and application of the right brake contributed to the right gear strut to bend. The right wing tip scraped the ground and minor damage…