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 20090607007859AGrtlks 2T1A2 · Hamilton, TX(-23) Pilot became lost. Pilot decided to land and ask his location. On short final approach pilot hit a tree with left main landing gear. Airspeed decayed so as to cause stall. Impact with ground sheared prop crankshaft and aircraft partially cartwheeled.…Accident 20090607007689ACessna 180J · Bellingham, WA(-23) On 06/07/2009 at approximately 17:13 PDT a Cessna 180J aircraft, serial number 18052550, [privacy data omitted] operated by [privacy data omitted] lost control during landing at the Bellingham International Airport (kbli) in Bellingham, Washington…Accident 20090606047249APiper PA-18-150 · Talkeetna, AKPilot stated he was landing at an off airport landing site when his aircraft began to stall. The right tire impacted the ground collapsing the gear (no safety cables). The aircraft came to stop striking the left wing to the ground bending the left aileron and…Accident 20090606047209APiper PA-18-150 · Tyonek, AKPilot reported landing on beach near chuitna river and did not like slope of landing area. Pilot attempted go-around and struck a pile of debris, damaging landing gear, prop, a wing strut, and left outboard wingtip.Incident 20090606019639IScwzer 269D · San Antonio, TXCatastropic failure of the oil cooler impeller resulted in loss of oil pressure. Helicopter was landed immediately. Damage to helicopter included cooling shroud, oil cooler support, oil cooler, turbine engine and fuselage skin around oil cooler impeller.…Accident 20090606014859ATcraft BC12D · Murray, IA(-23) The aircraft flying over a field surveying crops, the pilot lost control, stalled the aircraft and impacted the ground in a right wing low attitude.Accident 20090606010759AAmtr Searey · Knoxville, TN(-23) The pilot has successfully completed a touch-and-go water landing on melton hill lake. During an attempted left turn above the water, the aircraft lost it's lift capability and crashed (into melton hill lake).Incident 20090606010339ILockhe P38L5 · Fairmont, NE(-23) During takeoff roll at the Fairmont airport on runway 17, the right propeller began to surge and overspeed. The pilot elected to abort the takeoff and applied maximum braking. Both wheels were locked causing the right tire to blow out. Damage was…Incident 20090606010309IEpic Epiclt · Hartford, CT(-23) The pilot of N67PT, an experimental amateur built Epic lt, was operating the aircraft within the traffic pattern of Brainard airport (khfd) to maintain night currency. After approximately 3 traffic patterns the pilot departed runway 20 and entered left…Incident 20090606010129IDassau FALCON900FX · Laconia, NH(-23) Aircraft was on a visual approach to klci in night, VMC conditions. PIC stated there was no indication of any bird activity in the airport area. At approximately 75 ft above the airport PIC & SIC heard a loud bump in the rear of the aircraft apparently…Incident 20090606010119IEllington, CT(-23) Investigated a parachute jumping incident which occurred at approximately 0910 on June 6, 2009. The parachutist sustained a compound fracture to her ankle while landing in a residential area approximately 1000 feet northwest of the landing zone.…Incident 20090606010049IPiper PA34200 · Jeffersonville, IN(-23) Pilot reported that all three landing gear collapsed immediately after landing touchdown. Pilot stated that during the approach phase, all gear indication lights indicated down and locked ("down/three green"). He also stated that this indication was…Accident 20090606010009ADhav VAMPIREMK3 · Rochester, NY(-23) On June 6, 2009, at 1535 EDT, a Dehavilland vampire, N6878D, registered to wings of flight, inc., returned to the Rochester international airport (kroc) when at about 3500 feet MSL, the pilot heard a loud noise followed by an engine vibration, engine…Incident 20090606009829ISixchu SR7 · Jasper, TX(-23) N4846E a powered paraglider (experimental - operating light sport) took off of private property near Jasper, Texas. The pilot-in-command (PIC), a student pilot, took off a grass field into the wind with approximately 600' of clearing. After takeoff at…Accident 20090606008859AMeuerm SA900VSTAR · Winchester, TN(-23) Pilot indicated that he had accomplished 3 touch-and-go landings at the tullahoma airport. He then flew to the Winchester airport. Upon landing, he indicated that he applied the brakes and his aircraft veered to the right and off the runway.Accident 20090606008569ACessna 404 · Denver, CO(-23) On June 5, 2009 at 19:58 MST aircraft N37127, a Cessna 404 serial number 404-0114, experienced a gear-up landing damaging both props, several lower antennas,wing spar and underbelly skin (substantial). The aircraft was enroute from alamosa, CO. To…Accident 20090605857199ACessna 550 · Sellersburg, INThe pilot stated that a large bird struck the nose of the airplane on its initial climb. Pilot had just raised landing gear and estimated the aircraft was climbing at about 180 knots. The flight was about 1 mile north of the airport, 1,000 feet AGL at the…Accident 20090605011259AAmtr RANSS6ES · Williamsburg, MI(-23) Aircraft's left fuel tank was depleted. Aircraft's right fuel tank had 7-8 gallons of fuel.Accident 20090605011149AAmtr ROTORWAY162F · Barre Montpeli, VT(-23) On 06/05/2009, at approximately 1210 EDT a, amateur built rotorway 162F helicopter was destroyed when it made a forced/hard landing in berlin, VT. The one person onboard was fatally injured. VMC prevailed and no flight plan was filled for the local…Incident 20090605010039IPiper PA24 · Piqua, OH(-23) [privacy data omitted] was receiving dual instruction from [privacy data omitted]. After entering the traffic pattern at I17 (Piqua, Ohio), the pilot failed to extend the landing gear and landed on the runway gear up, the aircraft did leave the runway…Incident 20090605010029ICessna 172S · Jackson, MI(-23) Student pilot experienced nose tire failure on take off during first solo, attempted to maintain directional control, left main gear went off runway surface striking a runway edge light, light impacted on leading edge of left flap leaving small jagged…Incident 20090605009999IMaule MX7160 · Everglades, FL(-23) Pilot stated he failed to control aircraft during landing phase due to crosswind. He stated that the aircraft veered off the runway and impacted the trees.Incident 20090605009709ICasler CX4 · Chandler, AZ(-23) On June 5, 2009 at approximately 0800 MST, N5089Q was operating at 3000 feet when a piece of the propeller blade broke off and caused the engine to vibrate. The pilot shut down the engine and landed the aircraft on a dirt road. While landing the…Accident 20090605009629ABell 47G2 · San Marcos, TX(-23) Pilot performed landing approach to an agricultural field, attempting to cross a road under electiric power lines and telephone lines. As the helicopter crossed the road, the pilot ascended, catching the telephone line causing the helicopter to impact…Accident 20090605008659ABeech S35 · Decatur, TX(-23) Aborted takeoff, airspeed lower than minimum. Wet grass airstrip, could not stop prior to the end of the runway, impacted trees and collapsed left gear.Incident 20090605008279INamer SNJ4 · Caldwell, ID(-23) During attempted landing on runway 30 with gusty quartering tailwind at air show in waivered airspace, the airplane bounced several times and the left wingtip came into contact with the runway. The pilot performed a go-around and landed successfully on…Incident 20090605007429IPiper PA28140 · Albuquerque, NM(-23) On June 5, 2009 at 0930 MDT, N6693W, a PA-28-140, ground looped during landing at the Albuquerque International Sunport (kabq). The student pilot, the sole occupant of the aircraft, was not injured. The flight was being conducted as a supervised solo…Accident 20090604018059AHughes OH6A · Benson, AZ(-23) While practicing autorotation procedures, touched, down, aircraft jumped off runway, not enough RPM to maintain flight. Contracted ground second time and continued to move on ground rotating counter clockwise. Right side landing gear collapsed. Both…Accident 20090604011659AAmtr PITTSMODEL12 · Spicewood, TX(-23) After departing the Spicewood Airport, the amateur built pitts model 12, N922TP, lost power and the pilot made an emergency landing, beside the runway at Spicewood, TX. The aircraft sustained substantial damage. The pilot, was the sole occupant and…Accident 20090604009319AAmtr Zodiac · Clinton, AROn June 04, 2009 at 1100 CST a Zodiac CH601 hds, N90093Y rigistered to [privacy data omitted] took off from Clinton Municipal Airport (kcca) in Clinton Arkansas. Visual meteorological conditions prevailed at the time and VFR flight plan was not filed. During…Incident 20090604008769ICessna 750 · Salina, KS(-23) On June 4th, 2009, at approximately 1957 z (1457 local time CDT), a Cessna 750, operated under FAR part 135, was involved in an aircraft incident resulting from a bird strike that occurred during the landing rollout at the Salina Municipal Airport…Incident 20090604007439IPiper PA24180 · Arlington, TX(-23) Upon takeoff from kgky, pilot discovered that the gear would not retract completely and would not extend even with emergency gear extension procedure. Gear was in half-way position and jammed. Pilot conducted safe landing with the gear in the jammed…Accident 20090603047179AChampion 7ECA · Nome, AKThe pilot stated he was practicing off airport landings when he touched down he lost directional control and subsequently ground looped the aircraft. One of the main tundra tires had lost air pressure. Ptrs#AL01200902542Incident 20090603019349ISonexl Sonex · Oceanside, CADuring the short flight from fallbrook airpark to Oceanside airport, the pilot noticed that the rt CHT gauge rose above normal levels. Because the airman was closer to Camp Pendleton airport at the time his initial reaction was to head for Pendleton and land…Incident 20090603011399IBoeing 727233 · Memphis, TN(-23) On June 03, 2009, fedex express flight 1581 departed from Memphis, TN, enroute to norfolk, VA. On post flight the crew noticed the right outboard main landing gear tire missing. No abnormal indications were noticed on take off or landing. The tire…Accident 20090603009569ACessna 182M · Atlanta, ID(-23) Pilot departed on June 3, 2009 at 1400 MDT from boi airport on a personal flight. There was no flight plan filed. The a/c was last spotted at 8600' about 8 miles from Atlanta, ID at 1421 MDT. No further contact was made. The a/c was found 10 miles from…Incident 20090603008489IAmtr Sonex · Willmar, MN(-23) Pilot departed wilmar airport on an evening flight in his experimental Sonex aircraft. While flying se of the airport the engine suddenly quit. Prior to failure all engine indications appeared normal. Pilot was able to restart the engine but it was…Accident 20090603007839ABeech F33A · Midland, TX(-23) On June 3, 2009, at approximately 1635 CDT, the flight crew on N33UB, a Beech aircraft model F33A, attempted a flapless landing on runway 34 at Midland Airpark (mdd), Midland, Texas. This flight training was performed under the part 141 certificate to…Accident 20090603007789ACessna A188B · Kingstree, SC(-23) Pilot was in training to be an agriculture pilot and was using water in the hopper for practice, he was solo. He made a pass over a field spraying; he pulled up and was turning back to the field to set up a new spray line and then realized that he…Accident 20090602009409AAmtr Zenith · Crystal Spring, MS(-23) Witnesses reported that the aircraft was on base leg to land runway 17 when the engine quit. The aircraft continued in a westerly direction and hit a three inch diameter tree limb and crashed inverted into pasture, then caught fire. Both occupants of…Accident 20090602009289ACessna 140 · St Louis, MO(-23) Cessna 140 was DO8ING touch and go landings at Creve Coeur Airport (1H0). After the third touch and go the aircraft was refueled and the pilot took off on grass strip runway 25. One full stop landing was uneventful. On the fifth take off on runway 25,…Incident 20090602008249IArnetp Aventura 1 · Butler, TN(-23) This amphibious aircraft was attempting a water landing. The pilot indicated that he had to perform a last minute manuver to avoid contact with electrical power lines above the lake. He indicated that there was a black ball, embedded within the power…Accident 20090602008199ACessna A185F · Wenatchee, WAThe pilot stated that he was landing at hurst landing a private airstrip south of Wenatchee, WA. He landed long and struck a tree at about 10 miles per hour. The collision caused the aircraft to turn the aircraft and nose over on to the propeller. The landing…Incident 20090602008029IPiper PA24400 · Torrance, CA(-23) During approach for landing at toa, the landing gear was not extended and the aircraft sustained minor damage to the lower fuselage and propeller. The pilot indicated that he failed to extend the gear.Accident 20090602007699ACessna 172S · Tooele, UT(-23) The student pilot departed kslc on his first solo flight in a Cessna 172. The student had initially planned on entering the traffic pattern at ktvy, but he was not comfortable with the winds (variable 090-120 at 4-7 KTS) at ktvy and elected to do some…Accident 20090601047379APiper PA-28-235 · Elberton, GAMr. David w. dye, a student pilot, returned from a solo cross country flight from baldwin county airport (kmlj) in millidgeville, GA and came into land on runway 10 at Elbert county airport-Patz field (27A), his home airport. The descent and approach into…Incident 20090601009739IPiper PA46500TP · San Carlos, CA(-23) The pilot/owner states that he was landing at ksql in a crosswind using a considerable amount of rudder and aileron control in order to keep the aircraft from yawning and drifting off the runway center line. Upon landing on runway 30, the pilot states…Incident 20090531048969IBoeing 737-7BD · Nassau, BHPilot in command requested a climb to flight level 410 in an attempt to climb over a cumulus build up. The investigation indicated he exceeded the stall/buffet boundary margin for the aircraft weight resulting in a buffet condition which subsequently caused…Incident 20090531047539ICessna 172S · Kennesaw, GA[privacy data omitted] Was performing a crosswind approach and landing in N5339M on rwy 27 at Cobb county airport-mccollum field (kryy) on 05/31/2009 at 18:45 local time. The winds were variable 300 to 360 at 8 knots. While crossing the threshold, he felt…Accident 20090531047499ACessna 182P · Destin, FLWhile on a site visit on June 17, 2009, the aircraft was discovered at a local FBO to have substantial damage to the engine firewall, nose landing gear and propeller. In the pilots written statement; on may 31, 2009 he and three passengers departed from west…