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 20070610013539IGrtlks 2T1A2 · Longmont, CO(-23) The pilot stated that during run up at 1750 rpms the aircraft tipped on its nose. Damage was done to the prop. No injuries to the pilot.Accident 20070610013289ACirrus SR22 · Novato, CA(-23) The airplane owners [privacy data omitted] and CFI were returning from business and meetings the [privacy data omitted] had in las vegas. The owners are both student pilots. [privacy data omitted] Used the flight to north las vegas as a training flight…Incident 20070610012469IBell 206L3 · Hillsboro, TX(-23) This helicopter was in cruise flight when it struck a buzzard. The buzzard entered through the front windshield on the left side of the helicopter. The pilot landed the helicopter. The flight crew reported no injuries. A bird strike report was submitted…Incident 20070610012389IBoeing 7377H4 · Omaha, NE(-23) N767SW, B-737-100, was operated as southwest airline flight 1550, enroute from midway airport, IL, to oakland, CA. The crew declared an emergency and diverted to Omaha, NE due to smoke in the galley. The aircraft landed safely and taxied to the gate.…Incident 20070610012319IPiper PA28161 · Richards, TX(-23) In cruise flight at 2500 feet MSL, pilot experienced power loss from 2500 RPM to 1400 RPM. Pilot started maneuvering for an emergency landing. During maneuvering, pilot noted further degradation of engine RPM to 1100 RPM. Pilot successfully landed in an…Accident 20070610012219AAMD FALCON900 · Santa Barbara, CA(-23) Aircraft aborted takeoff after suspected control failure. Aircraft was unable to stop prior to end of runway. Aircraft departed end of runway and sheared off nose landing gear. Aircraft came to rest approximately 100 yards beyond end of runway.…Accident 20070610011389APiper PA12 · Koyukuk, AK(-23) ELT heard 02:30 z by rcc cap nome notified downed aircraft N78942 located by hageland aviation charter flt # state trooper on flight communicated with crashed aircraft pilot, established that there were pilot and pax injuries. Helicopter dispatched from…Accident 20070610010269APiper PA28161 · Redlands, CA(-23) Fire in engine bay, substantial damage to engine, wiring, lines, engine mounts, firewall and other engine mounted components.Accident 20070610010259ACessna 170A · Trenton, GA(-23) Upon landing at a Private grass strip known as praters landing, left gear went up a small knoll and caused aircraft to veer right. Pilot applied left brake in attempt to pull aircraft back to the left but aircraft had departed runway and begun a…Accident 20070610009939ACessna 170 · Anchorage, AK(-23) On approach to the north gasline airstrip, the left wing of the aircraft came into contact with trees located to the west of the runway. This contact resulted in an unstabilized approach causing an excessive rate of descent to touchdown. This caused the…Accident 20070610009849ACessna 150L · Greensboro, GA(-23) As pilot crossed numbers of runway 06, she encountered a gust of wind enough to push her approximately 50 feet to the right; airspeed was 65 mph. Pilot attempted to guide the aircraft back over the runway but was hit with another gust of wind and…Accident 20070610009579APiper PA16 · Esparto, CA(-23) Pilot stated that the winds were gusting, but not any worse than he has encountered before, at his private landing strip. He came in low and hit an irrigation ditch knoll. The pilot's wife is a CFI and started to tell him he was too low, but the…Accident 20070610009479ACessna 172D · Clay Hills, UT(-23) The pilot [privacy data omitted] departed the blanding, UT (kbdg) airport on 06/10/07 around 0830 to fly to Clay Hills. When he arrived at Clay Hills around 0900, he approached the landing area too high, too fast, and with a slight tailwind. He touched…Accident 20070610008669ACessna T188C · Angela, MT(-23) On June 10, 2007, at approximately 0930 local time, a Cessna CE-188-T188C, N2535J, registered to the pilot [privacy data omitted] sustained substantial damage when the left main gear failed during takeoff for expected aerial applications from a Private…Incident 20070609825129IBlanca 1730A · St Paul, MN(-23) Pilot stated he encountered a downdraft during approach for landing on runway 14. The right hand flap contacted the 8 foot 8 inch high approach lights located at station 600, which is 600 feet prior to the runway threshold. Weather data at 1553Z was…Incident 20070609018739IBeech D17S · Camarillo, CA(-23) After landing at high speed the pilot applied excessive braking causing the aircraft to nose onto the runway damaging the propeller. The pilot has been counseled.Incident 20070609013909IAmtr JODELF12 · Denver, CO(-23) At 1512 LCL pilot departed rwy 11L at bjc and approx 200'-300' the passenger door/canopy opened causing part of the latch and canopy to depart the aircraft. The pilot declared an emergency and returned and landed without incident. Pieces of the canopy…Incident 20070609012699IFleet FLEET7B · Malibu, CA(-23) N174RS, a Fleet 7B, made an emergency landing in a dirt field near the beach in Malibu, California, at 091830 PDT due to a rough running engine. No damage to the aircraft and no injuries to the two occupants.Accident 20070609011639AAmtr Glastar · Williston, FL(-23) The pilot and builder of N33CP elected to land on runway 14 at X60 in Williston Florida. The pilot landed short of the runway in the grass. The nosewheel collapsed and the aircraft flipped on its back. The pilot received minor injuries. The pilot has…Accident 20070609011609APiper PA38112 · Jacksonville, FL(-23) Aircraft suffered engine power loss at 500 feet horizontally from shore at an altitude of 500 feet. Pilot landed aircraft on beach, sustaining damage to the nose landing gear, engine mounts, propeller, engine firewall, and bulkheads under pilot seats.…Incident 20070609011579ICessna 172R · Raleigh/Durham, NC(-23) Aircraft landed on runway 5L and called ground control. Ground control instructed aircraft to taxi to the ramp. As aircraft taxied a crosswind gust hit the aircraft and spun the aircraft around causing a prop strike and the wing tip to hit the ground.…Accident 20070609010899ASchler ASK21 · Clear, AK(-23) This accident occurred during an airforce funded cadet training exercise. By definition an airforce mission (#A-20). The glider landed short of rwy 01 on a training flight, rolled into and on the pavement lip causing damage to the nose gear and damaging…Accident 20070609010799AScwzer G164A · Okarche, OK(-23) [privacy data omitted] while conducting weed control (spraying operation) at a feed lot (stockyard) located 8 miles east of Okarche, OK the outboard portion of the lower right wing struck a light fixture on a light pole, causing substantial damage to…Incident 20070609009279IMooney M20K · Kill Devil Hil, NC(-23) In a written statement from the pilot he realized after stopping that he forgot to extend the landing gear.Incident 20070609008339IAmegle EAGLET230 · Denton, TX(-23) The pilot experienced a loss of power enroute from gainesville (gle) to stage coach hills (4TX2) and made a successful emergency landing in a wheat field two miles south of the Denton airport. The pilot was not in contact with the Denton air traffic…Incident 20070608825069IMooney M20R · Flora, IL(-23) The aircraft landed gear up. This incident is closed with this report.Incident 20070608021089IAmtr Lancairivp · Hampton, GA(-23) During prelanding operations, it was observed the nose gear annunciator light was not illuminated. Pilot cycled gear 4 or 5 times but got the same results. Another aircraft was in the pattern so the pilot briefed an observation pass and the other pilot…Incident 20070608016609ICessna 150J · Yoakum, TX(-23) On 06/08/2007 at approximately 20:28 CDT a Cessna, N60866, CE-150-J, s/n 15070632, crashed while taxiing at the Yoakum Municipal Airport, Yoakum, Texas 77995. The incident occurred when the non-certificated person taxiing the aircraft lost control and…Accident 20070608013829ACessna A188B · Sargent, NE(-23) Pilot during aerial application was distracted looking for a map inside the aircraft. Aircraft struck a hilltop. Aircraft came to rest and a post impact fire destroyed the aircraft. Serious injuries to the pilot.Incident 20070608012039IDoug DC983 · Wichita, KS(-23) On June 08, 2007 at 0728 local time, aircraft N76202, flight #2007, while enroute from austin, Texas (aus) to chicago illinois-o'hare (ord), captain [privacy data omitted] contacted control tower at Wichita, KS (ict) and declared an emergency due to…Accident 20070608011749ABbavia 7AC · Erie, CO(-23) The pilot stated he was practicing touch and go landings to runway 33 (4,700 feet by 60 feet, concrete). The pilot stated that during the landing roll, the airplane got "squirrelly." The airplane departed the right side of the runway and nosed down in…Accident 20070608011279ABeech A36 · Gallatin, TN(-23) On 06/08/2007, at 0710 hrs the pilot [privacy data omitted] operated aircraft N729P a Beechcraft A36 bonanza, with three passengers on board from Gallatin, TN (M33) to knoxville, TN (tys). Upon arriving at knoxville and contacting approach control pilot…Accident 20070608010399ABoeing A75N1 · Coeur D'Alene, ID(-23) On June 8, 2007 at 15:30 gmt the pilot [privacy data omitted] was acting as pilot in command of N450SS, a 1942 Boeing A75N1 sterman. After departing spokane felts field airport (sff) the pilot [privacy data omitted] landed on runway 5 at the Coeur…Incident 20070608009369IMooney M20C · Everett, WA(-23) Pilot got distracted and did not verify a green gear down indication light when landing. Tried to put l/g down too late. The circuit breaker popped for the gear motor due to the a/c being too close to the ground. Once the a/c was lifted, the c/b was…Incident 20070607826309ICessna 182C · Milwaukee, WI(-23) The pilot [privacy data omitted] stated that after starting the engine he turned the aircraft to face south into the wind. While facing south on the ramp, and not moving the wind spun the aircraft around and up onto the left wing tip. Winds were…Accident 20070607014639APiper PA44180 · Lumberton, NJ(-23) The CFI and student onboard stated: after taking control of the aircraft from [privacy data omitted] (student), [privacy data omitted] (CFI) was unable to maintain pitch angle and directional control of N2173S while attempting a go-around during an…Accident 20070607012499APiper PA34200 · New Smyrna Bea, FL(-23) The failed prop hub has been examined by the NTSB. The engine has been sent to Lycoming for inspection by the NTSB with the FAA glro and hartzell as witness. The right (counter rotating) prop lost a blade in flight. The PIC, instructor pilot, made an…Accident 20070607011729ACessna 2105 · Quilcene, WA(-23) A/c departed lopez island at approx. 0900. Radar track shows the a/c at 1800 feet heading south. Weather was marginal VFR condition with local fog cover at lower altitude. Ceiling was approx. 1900 ft. the a/c impacted the 2000 ft hill after shearing off…Incident 20070607010009ICessna 310R · Homestead, FL(-23) At approximately 2230 hrs local, aircraft was inbound from (korl) orlando Florida and performed a normal landing on runway (9) at (X51) Homestead General airport. At approximately 2000 ft down the runway the aircraft "wobbled" and the left main landing…Accident 20070607009899ACessna 177 · Marion, AL(-23) During a repositioning flight from centerville, AL (O8A) to Marion, AL (AO8), engine lost power and pilot attempted an emergency landing on a dirt road, aircraft struck trees, coming to rest on an embankment alongside of the roadway. The aircraft…Incident 20070607009689IRobsin R22BETA · Phoenix, AZ(-23) Instructional flight out of ksdl. Practicing autorotations, flight terminated in a hard landing. No injuries to two on board, minor damage to aircraft.Incident 20070607009289ICessna 310C · Baltimore, MD(-23) Aircraft did not get 3 green lights when gear was cycled to the down position. Pilot flew by the tower and was told right gear was down but left gear was not completely down. Pilot tried to use emergency system but he still did not have 3 green lights.…Accident 20070607008289ACessna 172K · Amarillo, TX(-23) Pilot was making a crosswind landing on rwy 23 with winds from 250 degrees at 15 knots. At touchdown the left main landing gear leg fractured and separated from the aircraft, resulting in a loss of directional control. The aircraft drifted off the left…Incident 20070606023719ICessna 140 · Annapolis, MD(-23) Witnesses stated that the pilot [privacy data omitted] taxied aircraft N89692 into aircraft N757ZU on 6/6/2007 at approximately 1200 hours while taxiing to fuel his aircraft for a ferry flight to Delaware. N89692 had been previously issued a condition…Accident 20070606012229AAirtrc AT401 · Oak Grove, LA(-23) Engine lost power during turn-around maneuver at end of spraying pass and aircraft made an emergency landing in open field and became inverted after wheels contacted a ditch.Incident 20070606009719ICessna 414A · Stockton, CA(-23) Investigated assigned occurrence from western pacific daily report on 06/06/07. Report indicated pilot had "problems with a window." Subsequent telephone interview with company director of maintenance revealed that what in fact occurred was that the…Incident 20070606009379IPiper PA28R200 · Baytown, TX(-23) After take-off from la porte airport eastbound toward beaumont, the pilot initiated a power and an RPM reduction to 25" and 2500 rpm's, respectively. He initiated a slight climb at 1500 feet, reduced manifold pressure to 23 inches and attempted to…Incident 20070606008869IPiper PA24250 · Plymouth, MA(-23) On March 30, 2007 N7178P experienced a right main landing gear collapse due to rt MLG extend/retract conduit failure. The conduit was replaced may 7, 2007. On the first flight and landing June 6, 2007, on roll out the rt MLG again, collapsed. Incident…Accident 20070606008269AHughes 369D · Troy, OR(-23) On June 6, 2007 the pilot [privacy data omitted] was acting as pilot in command of N48MP a Hughes 369 helicopter performing game capture for the Oregon state departure of fish & wildlife. The pilot [privacy data omitted] is the owner of valley…Incident 20070605826729IBbavia 7GCB · Cloquet, MN(-23) Upon landing the aircraft bounced slightly and veered left as it crossed the intersection of the runways. The aircraft was off the runway before the pilot could react. The aircraft subsequently impacted a drainage ditch breaking off the right main gear.