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 20090520008719APiper PA20 · Glendale, AZ[privacy data omitted] Departed junction city municipal airport, Kansas, made three fuel stops along the way, with a final destination of Glendale Municipal Airport, Glendale, Arizona. He was landing at Glendale, runway 01. During the landing rollout, the…Incident 20090519010919IBeech 76 · Cahokia/St Lou, IL(-23) While traveling from topeka, KS (ktop) to St Louis Downtown Airport (kcps) on a personal flight. [privacy data omitted] Declared an emergency due to exhausting fuel approximately 8 NM from kcps, causing the right engine to fail. [privacy data omitted]…Incident 20090519008399IMooney M20M · Minneapolis, MN(-23) On may 19, 2009 at approximately 2220 hours local time, the pilot of N9153Y attempted to land at klvn airport. He approached the airport from the west for landing, as he was approaching, he felt the winds from the south push him off course. He decided…Accident 20090519006959ASocata TB20TRINIDAD · Tucson, AZ(-23) On may 19, 2009, at approximately 0850 MST, N62286, a trinidad TB-20, with [privacy data omitted] performing as pilot-in-command,landed gear up while performing touch and go landings at Marana northwest regional airport (avq). [privacy data omitted]…Incident 20090519006879IAmtr STARDUSTER2 · Killeen, TX(-23) On may 19, 2009 [privacy data omitted] acted as pilot in command his aircraft an experimental amateur built star duster ii registration number N227CJ to continue working on completing phase 1 compliance. After takeoff the engine lost power at 800 feet…Accident 20090519006319ABeech C35BEECH · Denver, CO(-23) Pilot started the takeoff roll and approx 1000 ft down the runway the nose gear collapsed and the mai gear partially retracted. An inspection of the aircraft was made and substantial damage was found. Also, the aircraft maintenance was no current and…Incident 20090518047219ICessna TR182 · Wellington, FLPIC reported that while on lookout for other approaching traffic, he got distracted and forgot to lower the landing gear on downwind. Airplane touched down smoothly on dry grass causing a minimum of airframe damage.Incident 20090518017949IAmtr Lancairlegac · Traverse City, MI(-23) Pilot landed on runway 36 at ktvc and admitted that he forgot to lower the landing gear, prior to landing.Incident 20090518009479IPiper PA22160 · Doniphan, MO(-23) Pilot [privacy data omitted] was doing touch and goes in aircraft N8156D. He stated on landing the left brake failed and would not pump up, although it was working before takeoff. He got to the end of the runway and was going slow enough he said he got…Accident 20090518008882ACessna 172N · Long Beach Que, CA(-23)An aircraft notified Long Beach ATCT that it observed two Cessna aircraft colliding over the ocean approximately 5 miles south of Long Beach queen mary, Long Beach, CA, at 1801 PDT on 05/18/2009. ATC radar data was used to track two targets originating…Accident 20090518008871ACessna 310P · Long Beach Que, CA(-23) An aircraft notified Long Beach ATCT that it observed two Cessna aircraft colliding over the ocean approximately 5 miles south of Long Beach queen mary, Long Beach, CA, at 1801 PDT on 05/18/2009. ATC radar data was used to track two targets originating…Accident 20090518008209ADiamon DA20C1 · San Antonio, TX(-23) Pilot (flight instructor) was demonstrating crosswind landings, in a/c N169PA, an diamond DA-20,. Acft rolled left over the runway dropping the left wing impacting the runway, rolled right over the runway beyond 90 degrees and finally rolled left down…Accident 20090518007119ABoeing A75N1 · Joshua Tree, CA(-23) While in cruise flight circling the airport the aircraft experienced an inflight fire. The pilot executed an emergency landing on runway 12, veered to the right and pitched up onto its nose. The pilot escaped the aircraft just seconds before it became…Accident 20090518007109APiper PA28181 · Milford, PA(-23) Operated under 14CFR part 91, pilot [privacy data omitted] departed white birch airport near lake wallenpaupack, PA, to somerset airport, NJ (ksnq) in VFR conditions pilot stated that engine stopped and made an off field landing. Aircraft came to rest…Accident 20090518006459ACessna A185E · Tacoma, WADuring roll out after landing at Tacoma Narrows Airport (tiw) the pilot of the CE-185 tailwheel aircraft lost control of the aircraft. The left wingtip struck the ground and was dragged approximately 30 feet. The aircraft came to a stop on it's nose balanced…Accident 20090517013539ABoeing E75 · Cottonwood, AZ(-23) The pilot and passenger were conducting a part 91 VFR cross country flight from san diego, CA to albuquerque NM. The flight path included a fuel stop at blythe CA prior to proceeding to an additional fuel stop in Cottonwood AZ. During the landing at the…Accident 20090517012439AStinso 10A · Winona, MN(-23) On 05/17/2009 Stinson aircraft N31584 departed la crosse, WI with a destination of Winona, MN. Aircraft had only reached an altitude of 1200 ft when the engine quit running. Pilot was unable to restart the engine and made an emergency landing that put…Incident 20090517009589IBell 407 · Denver, CO(-23) Several attempts have been made to contact medtrans but no response to date. This report will be forwarded to the NTSB for tracking purposes on bird strikes. The NTSB will continue future contacts with this company.Incident 20090517008639IAmtr Velocity · Wooster, OH(-23) The aircraft had been flown to wheeling, WV to have some interior work done and to be painted at a paint and interior facility, Ohio valley aviation. Upon departure from wheeling for bjj, the landing gear did not initially indicate up, then after…Incident 20090517008629ICessna 172P · Minneapolis, MN(-23) Aircraft departed eau claire, WI on 05/17/09 for the Crystal Airport in Crystal, MN where it landed at approximately 1330 hours local time. During landing rollout the pilot's footwear caused him to apply uneven pressure to the brakes which caused the…Incident 20090517007419IMaule MX7235 · Forest Grove, OR(-23) While landng on a private gravel road the aircraft veered to the right after touchdown, traveled approximately 70 feet through 48 inch tall nursey stock before nosing over and coming to rest inverted. The aircraft sustained minor damage. Neither the…Accident 20090517006949ACessna 172S · Flagstaff, AZStudent pilot [privacy data omitted] certificate number GG-0594067, while attempting to land on an initial solo cross country flight to Flagstaff, AZ, kflg, did lose control and crash. The aircraft, a Cessna 172, registration number N541ER, touched down…Accident 20090517006829APiper PA22150 · Las Cruces, NM(-23) On may 17, 2009 at approximately 1030 MDT, N8042D, a pipe PA22-150, registered to the pilot was landign at Las Cruces, NM airport (lru) to refuel after departing casa grande, AZ (cgz) earlier that day. The pilot reported that 10 or 15 seconds after…Incident 20090517005599IBeech A36 · Missoula, MT(-23) On may 17, 2009 @ 1522 MDT, a Beech A-36, N2024Q registered to [privacy data omitted], had an emergency landing at Missoula airport in Missoula Montana while on a personal flight. Visual meteorological conditions prevailed at the time, and a VFR flight…Accident 20090516857239AHelio H-295 · Kaktovik, AKLanding at 6500 feet on mccall glacier pilot encountered downdraft on final approach. Aircraft landed short of landing area on rough snowpack. Right ski encountered ice hummock bending ski axel and detaching ski.Accident 20090516047049AWinship Ken Dogger Craf · Palmer, AKAirman stated he lost control of his aircraft while attempting to land in gusty winds at the Wolf Lake Airport. Airman lost control of his aircraft, veered off of the runway and aircraft pitched down and went over on its back.Accident 20090516047039AMaule M-4-220C · Nenana, AKPilot stated that while landing on runway 4L he ground looped the aircraft causing damage to the propeller, the left gear, and the left wing tip.Accident 20090516047029ACessna 170B · Nenana, AKPilot stated while back taxiing he observed a wind gust that raised his upwind wing, he attempted to take off by "firewalling the throttle" and got to about 20' AGL then the aircraft stalled causing damage to the left wing, right tip cap, engine prop, left…Accident 20090516025829APiper PA-24-250 · Wasilla, AKAt approximately 1140 adt, pilot was returning to anderson lake strip, Wasilla (0AK1). Pilot reduced power and when carb heat was applied engine died. Pilot had just done a touch and go and was at 1700 AGL. The pilot turned around hoping to glide back to…Incident 20090516025189ICessna 182A · Dry Bay, AKOn may 16, 2009, about 1325 Alaska daylight time, a Cessna 182A, N2054G, nosed down on a loose and sandy beach during an off airport precautionary landing following a partial loss of engine power at Dry Bay, Alaska. The pilot was operating the airplane under…Incident 20090516010939IMooney M20M · Orlando, FL(-23) The right main landing gear collapsed after landing and rollingout approx 1000' - 1500'. The pilot maneuvered the aircraft off the taxi way into the grass area to prevent any damage or block the taxiway.Accident 20090516010019ACessna 172N · Blythe, CA(-23) The aircraft lost power landed in the desert on uneven terrain, and came to rest upside down.Incident 20090516008759ICessna T210L · Paola, KS(-23) On may 16th, 2009, at approximately 1330 z (0830 CDT), a private pilot was involved in an aircraft incident resulting from a gear-up landing at the Miami County Airport (K81), Paola, Kansas. The aircraft involved in this incident is a Cessna T-210-L,…Accident 20090516008679AUnivar 415C · Gallup, NM(-23) On may 16, 2009 at approximately 1155 MDT, N94300, an Ercoupe, 415C, registered to the pilot was taking off runway 6 at Gallup, NM airport (gup) for a local "eaa young eagle" flight. The pilot reported that he was about 300' AGL when the aircraft…Incident 20090516006729IPiagio P180 · Redmond, OR(-23) While landing at private airstrip the aircraft struck a deer with the right main landing gear. The pilot aborted the landing and diverted to rdm. Emergency services were alerted and standing by when the aircraft arrived at rdm. Upon touchdown on rwy 28,…Incident 20090516006569ISnias AS350B3 · Simla, CO(-23) Duck came through chin bubble. Aircraft landed immediately and called for second aircraft to transport patient. Simla fire and police secured aircraft until air methods recovered it.Incident 20090516006509IBombdr DHC8402 · Boston, MA(-23) On two mile final requested be met by medical personnel due to possible injury to a flight attendant. F/a was taken to hospital. Injury determined to be a severe strain to left foot and ankle.Accident 20090516006369ADiamon DA40 · Norwood, MA(-23) [privacy data omitted] was on his first solo flight. He was being watched by his instructor pilot, [privacy data omitted]. [privacy data omitted] Stated it was a normal landing as did [privacy data omitted]. At landing the right main collapsed yawing…Accident 20090516006282ACessna 172M · Burlington/Mou, WA(-23) Aircraft conducting a 135 on-demand charter in a Cessna 172, made a normal landing to runway 28 at Skagit Regional Airport (bvs) and during the rollout had another aircraft, a pitts model 12, land on top of the left wing causing the aircraft to sustain…Accident 20090516006271AAmtr PITTSMODEL12 · Burlington/Mou, WA(-23) An airline transport pilot and his passenger were returning to the Skagit Regional Airport from a personal part 91 flight in the pilots pitts model 12 aircraft, when the pilot of the pitts landed on top of a Cessna 172 aircraft conducting a part 135…Accident 20090516006269AVenus · Kuna, ID(-23) Non-certificated pilot stated the two place unregistered Venus lost power for unknown reasons and landed hard in a pasture nose wheel first destroying the aircraft. The non certificated pilot and passenger received injuries from the accident. The FAA…Accident 20090515047529ARaytheon Ai A36 · Beauregard, ALAircraft experienced engine trouble while in cruise flight. Pilot contacted atlanta approach and requested vectors to nearest airport. Pilot did not inform ATC of engine trouble/failure. Pilot was trying to reach the auburn-opelika airport (kauo) but could…Accident 20090515047189APiper PA-32-301 · Eagle River, AKTelephone interview with pilot [privacy data omitted] about aft cargo door top leaving aircraft in flight see attached pilot narrative. It appears the j hook was not making proper contact with the upper loop and the top of the door popped out into the wind…Incident 20090515047109ITaylorcraft BC12-D · Kodiak, AKPilot stated on 05/29/2009 via phone that he t/o from runway 02 at airport kdk on 05/15/2009 at approximetly 1430. Engine started to sputter after t/o approx. 300 ft. altitude. Pilot made shallow turn back to kdk and landed on r/h side of runway 200.…Incident 20090515025599IAgusta AB139 · Deadhorse, AKCrew failed to ensure that the cargo door was properly latched. The door was closed and after reaching cruising speed the door began sliding open and departed the aircraft.Accident 20090515025199APiper PA-18-150 · Kenai, AKTelephone interview with owner/pilot [privacy data omitted] on 5/22/09. After landing on a friend's dirt/sandy strip about 25 miles west of Kenai, he taxied to the end and while manuevering around his friend's a/c, the left wing leading edge hit a tree about…Incident 20090515009229IBoeing E75 · Reno, NV(-23) Landing runway 08 at 4SD on a clear day with a light breeze at about 110 degrees. Normal approach and flare. The pilot stated he was lulled into a relaxed state expecting a normal landing. The stearman is an airplane that has zero tolerance for a pilot…Accident 20090515007769AAirtrc AT602 · Charleston, MO(-23) Aircraft heavy with dry fertilizer (potash) and fuel failed to acquire airspeed and altitude enough to clear standing wheat at the end of the 2400 foot air strip. The drag of the wheels in the wheat caused the aircraft to desend, pitch down and flip…Accident 20090515007069AUnivar 415C · Mammoth, AZ(-23) The student pilot and sole occupant of the aircraft was conducting a part 91 VFR cross country flight from punkin center, AZ to san manuel airport, san manuel, AZ (E77). The pilot stated the he experienced a sudden loss of engine power while in cruse…Incident 20090515006969ICzawsp Sportcruiser · El Monte, CA(-23) Pilot stated that upon landing he made a main gear landing and slowly lowered the nose wheel. When the aircraft settled onto the nose wheel he heard a loud "boom" and the nose of the aircraft fell to the runway destroying the porpeller and causing minor…